hide progress bar symbol for no values
Is there a mechanism in the formula to hide the progress bar symbol when the row should not contain a progress bar (i.e. work may not apply)?
I have the following formula that works fine, but if an item is out of scope, I don't want there to be a progress bar shown at all.
=IF([AMS Complete]3 = 0, "Empty", IF([AMS Complete]3 = .25, "Quarter", IF([AMS Complete]3 = .50, "Half", IF([AMS Complete]3 = .75, "Three Quarter", IF([AMS Complete]3 = 1, "Full", IF(AND(ISBLANK([AMS Complete]3),ISBLANK([In Scope?]3),"","Empty"))))))
Answers
-
You can change the order of the logic to first check if the item is in scope. If no, have it equal "", if move on to modify the progress bar. I am using a checkbox for "In Scope?" but it would work for other column types if you change the =0 to fit the criteria in question.
Formula
=IF([In Scope?]@row = 0, "", IF([AMS Complete]@row = 0, "Empty", IF([AMS Complete]@row = 0.25, "Quarter", IF([AMS Complete]@row = 0.5, "Half", IF([AMS Complete]@row = 0.75, "Three Quarter", IF([AMS Complete]@row = 1, "Full"))))))
Output
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Thank you so much Dan. It looks as though I needed to control the visibility essentially in the first IF statement and then if it was visible to then display the progress.
I really appreciate the assistance there!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!