IF statement with Incorrect Argument Set

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

Answers

  • Suzanne Raphael
    Options

    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
    Devin Lee ✭✭✭✭✭
    Options

    @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)
    

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!