Automation
I'd like to create an automation to send a notice to a coordinator when days worked are within 2 days of Days allowed to work. I'd also like to add a conditional format that highlights the row. Please help.
Best Answer
-
Hi @LHurley!
Assuming 'days worked' and 'days allowed' are the column names, you can set up a helper column with a formula like so,
=IF([days worked]@row + 2 = [days allowed]@row, 1, IF([days worked]@row - 2 = [days allowed]@row, 1, 0))
This will allow you to see if the days worked are +/- 2 days from days allowed. From there you can set up an automation where if the helper column changes to 1, send a notification to the coordinator. You can also use conditional formatting to highlight the row if the helper column is 1.
Hope this helps!
Answers
-
Hi @LHurley!
Assuming 'days worked' and 'days allowed' are the column names, you can set up a helper column with a formula like so,
=IF([days worked]@row + 2 = [days allowed]@row, 1, IF([days worked]@row - 2 = [days allowed]@row, 1, 0))
This will allow you to see if the days worked are +/- 2 days from days allowed. From there you can set up an automation where if the helper column changes to 1, send a notification to the coordinator. You can also use conditional formatting to highlight the row if the helper column is 1.
Hope this helps!
-
Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives