Calculate Overall Status from Multiple Columns
I have a sheet with statuses in multiple columns, and I'm calculating overall status by using CONTAINS looking at the columns. This works just fine, except for one complication. When one or more columns is Complete, and one or more columns is Not Started, I need to show the overall status as In Progress.
Any ideas on how to do this?
Help Article Resources
Check out the Formula Handbook template!