Formula for Status

edited 12/09/19

I have a team task list sheet that has a drop-down Status column including Not Started, In Progress, Urgent, On Hold and Completed and we use card view for this. I have a % Complete column that is a text/number field and a Progress symbol column (Empty, Quarter, Half, Three Quarter & Full).

Is there a formula that could be used in the Progress column to do the following?

If Status is Not Started or On Hold = Empty

If Status is In Progress or Urgent = % Complete (Quarter, Half or Three Quarter)

If Status is Completed = Full

Tags:

• ✭✭✭✭✭✭

Try something like this...

=IF(Status@row = "Completed", "Full", IF(OR(Status@row = "In Progress", Status@row = "Urgent"), IF([% Complete]@row >= .75, "Three Quarter", IF([% Complete]@row >= .5, "Half", IF([% Complete]@row >= .25, "Quarter", "Empty"))), "Empty"))

• Thank you. This worked.

• ✭✭✭✭✭✭

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!