RYG Status based on Variance
Greetings,
Does anyone know if there is a formula to automate RYG based on Variance? I am trying to track budget (not dates). I would like to show Red balls when a task is over budget.
Any ideas on the formula?
Thank you!
Comments
-
I think there are a variety of ways to accomplish what you are trying to do. Are you trying to figure variance on a row by row basis or by sum total of the entire budget for the sheet like for a roll-up?
Here are two examples of formulas you could use:
Row by Row: =IF(Actual@row > Budget@row, "Red", "Green")
Sum of Columns: =IF(SUM(Actual:Actual) > SUM(Budget:Budget), "Red", "Green")
You can see both of them at work in my screenshot below. Right click on it to open it in a new window. You can see the item flagging red, while the overall budget is still on track. Hope that helps!
-
Did this solution work for you?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!