Auto emails
We want to send a 5 question 'Pulse check' to new employees starting from 3 months after they start for 6 months.
I have created the smartsheet form with the questions. I have a seperate smartsheet with employee name and start date etc.
How can I send auto reminders? I looked at sending a workflow from the employee smartsheet but struggled to see how to make it specific to that employees start date and only look at employees that have been with the company between 3 months and 9 months.
Best Answer
-
Sure!
First you will need to create a column to indicate the duration in months using formula such as =INT(MONTH([Start Date]@row)).
Then you can create a workflow using templates such as "Request an update when specified criteria are met".
Add a condition using the duration column adding the range e.g where duration is between 3 to 6.
Finalize workflow by indicating how and who to send it to.
I hope that helps
Answers
-
Hi @Josephine
Hope you are doing well!
I recommend including the form link in a workflow in the employees sheet.
The workflow will run on the time frame you intend to capture, then send the link to their emails.
Please let me know if you require further clarification.
-
Hi Okey, Thanks for your response.
Yes comfortable with the first part but its how to set up the workflow so it is emailing out monthly but only capturing employees within 3 months and 9 months of their start date.
-
Sure!
First you will need to create a column to indicate the duration in months using formula such as =INT(MONTH([Start Date]@row)).
Then you can create a workflow using templates such as "Request an update when specified criteria are met".
Add a condition using the duration column adding the range e.g where duration is between 3 to 6.
Finalize workflow by indicating how and who to send it to.
I hope that helps
-
Hi @Josephine,
I noticed the discussion is still open. Please let me know if you are still having issues. 🙃
-
Hi @Okey
Long weekend here so just getting back to this - thanks for your response, I think that will do the trick!
-
Anytime @Josephine. Hope you have a lovely week
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives