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
-
You would need to set up a helper column (flag type in this example) and then use a basic comparison IF statement to flag any rows where the savings goes below the target. From there you would set up your conditional formatting and automation to trigger based on this column being flagged.
=IF([2023 Calendar Savings]@row< [2023 Budget Target]@row, 1)
Answers
-
You would need to set up a helper column (flag type in this example) and then use a basic comparison IF statement to flag any rows where the savings goes below the target. From there you would set up your conditional formatting and automation to trigger based on this column being flagged.
=IF([2023 Calendar Savings]@row< [2023 Budget Target]@row, 1)
-
Worked perfectly. Thanks Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!