Checkbox condition statement

=IF(OR([Assigned To approval]8 = "Approved", "Declined", "Submitted"), 1, 0)


How do I edit this formula to check the checkbox if the [Assigned To approval]8 cell says Approved, Declined or Submitted.


Formula says invalid now

Answers

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭

    Hi Jennifer,

    This is not how the OR formula is supposed to work.

    OR needs to separates every condition, so your formula should be written like this:

    =IF(OR([Assigned To approval]8 = "Approved", [Assigned To approval]8 ="Declined", [Assigned To approval]8 ="Submitted"), 1, 0)

    But if [Assigned To approval]8 can only have the value "Approved", "Declined" or "Submitted", I would rahter suggest this formula:

    =IF(NOT(ISBLANK([Assigned To approval]8)),1,0)

    Would work in the same manner as the checkbox will get checked each time there's something within the cell.

    But if you have more possible values within [Assigned To approval]8, then go with OR.


    Hope it helped!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!