Automated Email Reply After x Amount Of Days
I am looking for a way to set up a workflow so that once a box is checked, an automated email will get sent out to a person a few days later.
Answers
-
The first step is setting up a Record A Date automation to populate the date in a date type column when the box is checked. Then you would use another date type column with a formula to output the desired automation send date based on the Record a Date column. Finally you would set up your email send automation to run on this second date column.
-
@Paul Newcome how would I write the formula if I need to run the automation when column A is either "a, b, or c"?
Right now I have something like this =IF(About@row = "A", [Auto Date]@row + 30). This works for that choice, but I need it to work if the "about" column is also B or C.
-
You would use an IF/OR.
=IF(OR(About@row = "A", About@orw = "B", About@row = "C"), ...............)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives