Triggers over/under specific variance
NuGen Team
✭✭
Could someone help provide steps on how we would get a WORD TRIGGER to appear if the value is over 4% or under 4%?
Answers
-
You can use an IF function to evaluate if the value in the column with your percentages in is over 4% and have this return different text depending on whether this is true or false. Percentages are stored in smartsheet as decimals if the column format is percent so your formula would be
=IF([column with %]@row > 0.04, "OVER 4%", "UNDER 4%")
If you prefer to include any that are exactly 4% as being over 4% then you can use >= instead of >
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives