Help with setting a symbol color based off calculation
Hello,
So I have two columns. Actual and Budget
I want to calculate the difference between the two, and then if the difference is lower than the budget number, the indicator symbol would be green, else if it is higher, the indicator symbol would be red. Thoughts on how that would look in a formula. TY
Answers
-
Hi @Buster Davis,
Your formula would like this for a traffic light symbol column:
=IF(Actual@row <= Budget@row, "Green", "Red")
Result:
In the formula, it is set to be green if the budget matches the actual, if you would prefer this to be red in this circumstance then remove the 2nd = sign.
Hope this helps; if you've any questions etc. then just post! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!