% Complete and Symbols
Hello  does anyone know how to create a formula that when a certain symbol is selected, it will return a status? Screen shot below.
Empty; return status 'Not Started'
Quarter, Half, or Three Quarter; return status "In Progress"
Full, return status "complete"
Thank you for your help!
Best Answers

I missed a parenthesis. Sorry about that.
=IF([% Complete]@row = "Empty", "Not Started", IF([% Complete]@row = "Full", "Complete", "In Progress"))

Thank you! I ended up figuring out this: =IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row <= 0.99, "In Progress", IF([% Complete]@row = 1, "Complete")))
And it seemingly works, at least for now! Appreciate your help!
Answers

Try this:
=IF[% Complete]@row = "Empty", "Not Started", IF([% Complete]@row = "Full", "Complete", "In Progress"))

Thank you for responding! It says "unparseable".

I missed a parenthesis. Sorry about that.
=IF([% Complete]@row = "Empty", "Not Started", IF([% Complete]@row = "Full", "Complete", "In Progress"))

That worked! Thank you so much!!

Happy to help. 👍️

Hi Paul,
My team has requested that instead of the symbols we use percentages. Can you help me with a formula that does the same thing, but instead uses these indicators:
0%; return status 'Not Started'
25%, 50%, or 75%; return status "In Progress"
100%, return status "complete"
Under the % complete column I have changed the drop down options to be 0%, 25%, 50%, 75%, 100%
Thank you!

@mwinfree You would use the same formula but instead of using "Empty" you would use "0%", and instead of "Full" you would use "100%".
Future Note:
This only works because you are using a dropdown to populate the % Complete. If you were going to use a text/number type column formatted for percentages, you would use 0 and 1 for 0% and 100% (no quotes and no % symbols, just zero and one).

Thank you! I ended up figuring out this: =IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row <= 0.99, "In Progress", IF([% Complete]@row = 1, "Complete")))
And it seemingly works, at least for now! Appreciate your help!
Help Article Resources
Categories
Check out the Formula Handbook template!