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
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives