Checkbox condition statement

Jennifer Flanagan

=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

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!