RYG Status based on Variance

ChristineD

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!

Mike Wilday

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! 

Mike Wilday

Did this solution work for you?