Checkbox based off of dropdown selection.

jon.peters
edited 12/09/19 in Formulas and Functions

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. 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!