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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!