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
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives