Automation or Formula to Alert Someone When a Number Falls Below Another Number

I have two columns 1. 2023 Calendar Savings and 2. 2023 Budget Target.

What would the automation or formula be

If 2023 Calendar Savings falls below 2023 Budget Target amount then 2023 Calendar Savings changes to RED and alerts specific person



Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!