# variance

edited 12/09/19

I have two numbers or dates

Baseline budget 100,000

Current budget 35,000

Variance is 65,000

If I do a  % calculation (variance/baseline) then its 65%

I have a health indicator that says if the variance is > 10% then red, more than 5% and < 9% then yellow, lower then green.

However, we are WAY under budget in this example so it goes red - how do I fix?

sorry I'm being dense

Tags:

• ✭✭✭✭✭✭

Hi Matthew,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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.

• ✭✭✭✭✭✭

You ask how to fix. What are you currently getting that is incorrect?

Assuming you have a separate column to calculate the percentage, you would use something along the lines of...

=IF([Variation % Column]@row >= .1, "Red", IF([Variation % Column]@row >= .05, "Yellow", "Green"))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!