Automate symbols
This should be easy but I am stuck trying to figure out how to get the symbols to work in a formula to reflect health of budget percentages.
All the single lines work except the green one - it just shows up blank, with no error (the highlighted drop-down has the green formula only like below) I have tried the combo forumla and got the unparsable error. What am I missing??
Thank you to whoever helps out!!
Angela
Answers
-
I'd nest your if statements within each other.
=if([Budget vs Actual %]@row <= 10, "Red", if([Budget vs Actual %]@row <= 20, "Blue", if([Budget vs Actual %]@row <=30, "Yellow", "Green")))
Does that get you what you're looking for?
Ryan
-
Thanks Ryan - I plugged that in and it gave me all red circles.
Will keep trying.
A
-
I hope you're well and safe!
Try something like this.
=if([Budget vs Actual %]@row <= 0.1, "Red", if([Budget vs Actual %]@row <= 0.2, "Blue", if([Budget vs Actual %]@row <=0.3, "Yellow", "Green")))
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yay! Brillant - I did not think to use decimals.
Thank you so much!
One more question - can I change the blue dot to orange instead? Can't figure out how to fix that in the column settings.
Thanks!
A
-
Excellent!
Happy to help!
Unfortunately, you can't change it to orange using symbols, but...
You can use other symbols by using UNICHAR, CHAR, or Emojis.
More info:
www.getemoji.com
A great resource that Paul Newcome put together
Would that work/help?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!