Circular Dependency issue

AppSheet AppSheet Q&A
,
1

Hi all,

In my app, I have the following expression:

IFS(

AND(
ISNOTBLANK([Procedure Code 01].[Modifiers]),
ISNOTBLANK([Procedure Code 01]),
CONTAINS(
[Procedure Code 01].[Suggested Modifier], “0067”),
[Add Microsurgery (of Larynx) modifier? (0067)] = TRUE),
CONCATENATE([Procedure Code 01].[Modifiers]&“, 0067”),

AND(
ISNOTBLANK([Procedure Code 01].[Modifiers]),
ISNOTBLANK([Procedure Code 01]),
ISBLANK([Add Microsurgery (of Larynx) modifier? (0067)])),
[Procedure Code 01].[Modifiers],

AND(
ISNOTBLANK([Procedure Code 01].[Modifiers]),
ISNOTBLANK([Procedure Code 01]),
[Add Microsurgery (of Larynx) modifier? (0067)] = FALSE),
[Procedure Code 01].[Modifiers],

AND(
ISBLANK([Procedure Code 01].[Modifiers]),
ISNOTBLANK([Procedure Code 01]),
CONTAINS(
[Procedure Code 01].[Suggested Modifier], “0067”),
[Add Microsurgery (of Larynx) modifier? (0067)] = TRUE),
[Procedure Code 01].[Suggested Modifier],

AND(
ISNOTBLANK([Procedure Code 01]),
ISNOTBLANK([Procedure Code 01].[Modifiers])), [Procedure Code 01].[Modifiers])

ISSUE:

I need to add this as the first nested IFS statement, but it keeps telling me I have a circular dependency :

OR(
AND(
OR(
CONTAINS([Procedure Code 01], “1101”),
CONTAINS([Procedure Code 01], “1105”),
CONTAINS([Procedure Code 01], “4903”)),

CONTAINS([Procedure Code List], “1052”)),

AND(
OR(
CONTAINS([Procedure Code 01], “1101”),
CONTAINS([Procedure Code 01], “1052”),
CONTAINS([Procedure Code 01], “4903”)),

CONTAINS([Procedure Code List], “1105”)),
AND(

OR(
CONTAINS([Procedure Code 01], “1101”),
CONTAINS([Procedure Code 01], “1105”),
CONTAINS([Procedure Code 01], “1052”)),

CONTAINS([Procedure Code List], “4903”)),

AND(
OR(
CONTAINS([Procedure Code 01], “1105”),
CONTAINS([Procedure Code 01], “4903”),
CONTAINS([Procedure Code 01], “1052”)),

CONTAINS([Procedure Code List], “1101”))), “0005”,

Any possible way of getting any assistance with this? It’s driving me INSANE. Thanks so much.

2

The most common Circular Dependency occurs when you have at least 2 columns whose value derivation depends on the updates being made in the other column that also depends on the first column. Something needs to be done to break the circular reference somehow.

Since the NEW part you are trying add introduces a additional column, [Procedure Code List], there must be something in its App Formula or Initial value that is causing the circular reference. Can you show the expressions from column [Procedure Code List]?

Also, based on what you have shown so far, you may want to consider a table driven approach which will help simplify the expression but may also eliminate the circular reference issue.

1 Like
3

Thanks so much. I had a look at that column and discovered that it depended on another for info, which actually overlapped, hence the circular ref. Really appreciate your time, go well.