Checkbox based off of dropdown selection.
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.
Help Article Resources
Check out the Formula Handbook template!