Formula for Status

Heather K

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

 

Paul Newcome

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"))

Heather K

Thank you. This worked.

Paul Newcome

Happy to help!