Progress Bar Not Responding to Parseable Formula
I've searched high and low but cannot find the answer: my formula for the Progress Bar is NOT coming back "Unparseable", yet nothing is happening in the column. Here is the formula I have for my Completion Progress column, which is successfully tied to my %Complete column (which has the dropdown option 1.00 that converts to 100% in the cell when selected):
=IF([%Complete]@row = "100%", "Full")
I haven't input into the formula the remaining 0 for Empty, .25 for Quarter, .50 for Half, or .75 for Three Quarter, yet, because I wanted to get this figured out.
So when I enter 1.00 (100% inside the cell) into the %Complete column, nothing happens in the Completion Progress column. Can someone please help me? I've spent days trying to figure out these formulas for automation and it's proving counterproductive of my time. Thanks so much!
Best Answers
-
Hi @ssummer,
Try changing the "100%" to 1.
=IF([%Complete]@row = 1, "Full")
The others would be .25, .50, and .75.
Hope this helps,
Thanks.
-
That worked! Thanks so much!!!
Answers
-
Hi @ssummer,
Try changing the "100%" to 1.
=IF([%Complete]@row = 1, "Full")
The others would be .25, .50, and .75.
Hope this helps,
Thanks.
-
That worked! Thanks so much!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!