% 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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!