% Complete and Symbols

mwinfree

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!

Paul Newcome

I missed a parenthesis. Sorry about that.

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

mwinfree

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!

Paul Newcome

Try this:

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

mwinfree

Thank you for responding! It says "unparseable".

Paul Newcome

I missed a parenthesis. Sorry about that.

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

mwinfree

That worked! Thank you so much!!

Paul Newcome

Happy to help. 👍️

mwinfree

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!

Paul Newcome

@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).

mwinfree

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!