IF statement with Incorrect Argument Set

System

This discussion was created from comments split from: IF Function and Checkboxes.

Suzanne Raphael

Related, I have a "Status" column with single-select drop-down, and a "Complete" checkbox column. Want to accomplish:

1. When Complete is selected in the Status column, I want the checkbox in the Complete column to tick.
2. When the checkbox in the Complete column is ticked, I want the drop-down in the Status column to select complete.

So a reciprocal/2-directional thing. I don't mind using 2 formulas, and actually would prefer separate to minimize the complexity and boost re-usability/portability.

Right now, I'm trying to accomplish just the first part with:

=IF(Status@row = "Complete", Complete@row, 1, 0)

But get "INCORRECT ARGUMENT SET" ... why??

Devin Lee

@Suzanne Raphael,

You will get a circular argument if one formula can trigger the other. You instead want to use two automations.

On a side note you got an INCORRECT ARGUMENT SET because you had too many agruments and it should look like something like this

=IF(Status@row = "Complete", 1, 0)

Suzanne Raphael

@Devin Lee Cool. Thanks!