Phase of Work Formula

Jim Schaffhausen
Jim Schaffhausen ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello Community-

I am looking for help with a formula to tell me what phase of work the project is in. The formula will be looking at 5 checkboxes in columns. If I complete the last checkbox in the first phase, but have not completed the last 2nd phase checkbox, I would like the column "Project Phase" to return the 2nd phase name.... Here is a screenshot for what I am trying to do. Any help would be appreciated.

Smartsheet Phases.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!