Nested IF-AND-OR within the same cell...
I am trying to automate a cell based on the status selected in 5 different cells (all within the same sheet)
First 5 columns has the following Statuses.
Main status is 'Complete' when all 5 columns are 'Complete'
Main Status is 'Incomplete' when at least one of the columns is 'Incomplete'
Main status is 'In Progress' when at least one of the columns is 'Complete' and others are 'Scheduled'
Main Status is 'Sick' when at least on of the columns is 'Sick'
Main Status is 'Dropout' when at least one of the columns is 'Dropout'
Main Status is 'Cancelled' when at least one of the columns is 'Cancelled'
Main Status is 'Scheduled' when all 5 columns are 'Scheduled'
I would want to check all the above conditions within the same cell. I am fairly new to smart sheets and still trying to figure this out. Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!