IF AND statement

Joshua Rudesill

I am attempting to build out a system which checks a box based on a hidden checkbox and a drop down field.

If the hidden checkbox is checked, and the dropdown field shows either "In Progress" or "Not Started" the visible checkbox is checked.

If the hidden checkbox is checked, and the dropdown field shows "Complete" the visible checkbox is unchecked.

If the hidden checkbox is unchecked, no matter the dropdown field, the visible checkbox is unchecked.

Here is the code I have, any help or input is very much appreciated.

=IF(AND([Hidden Checkbox]@row = 1, Status@row = "In Progress" "Not Started"), 1, IF(AND([Hidden Checkbox]@row = 1, Status@row = "Complete", 0)))

David Tutwiler

I think all you have to solve for is checked as all other conditions will result in unchecked. Something like this should do the trick:

=IF(AND([Hidden Checkbox]@row = 1, OR(Status@row = "In Progress", Status@row ="Not Started")), 1, 0)

David Tutwiler

I think all you have to solve for is checked as all other conditions will result in unchecked. Something like this should do the trick:

=IF(AND([Hidden Checkbox]@row = 1, OR(Status@row = "In Progress", Status@row ="Not Started")), 1, 0)

Joshua Rudesill

Thanks, that worked. I was moving that direction but this clears things up.

David Tutwiler

Awesome, glad it works.