Checkbox based off of dropdown selection.

jon.peters

I'm trying to create a formula in a checkbox column. This column is called complete. I would like the complete column to automatically check once one of two statuses from a status column is selected. The status column has a number of statuses, but the two I need are "Hold/Cancelled" and "Complete".

I created an IF statement if one of the criteria are met, but I can not get the two to work together. 

=IF(Status2 = "Hold/Cancelled", 1) 

=IF(Status2 = "Complete", 1) 

How do I get these two within one statement to work together. 

Dave Stanley

You can accomplish this by using the OR operator in your function.  

=IF(OR(Status2 = "Hold/Cancelled",Status2 = "Complete"),1,0) 

jon.peters

Dave, you are a genius. I can't tell you how long I fought with that syntax. This worked like a charm. Thank you!