RYG Status based on Variance

ChristineD ✭✭
edited 12/09/19 in Formulas and Functions


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
    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
    Mike Wilday ✭✭✭✭✭✭

    Did this solution work for you? 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!