Hello,

I am currently working on a digital performance evaluation. I have created a smartsheet with employees names, supervisor email, 30 day review date, 60 day review date, and 90 day review date. I have created a smartsheet survey for the employee to complete and a survey(evaluation) for the supervisor to complete. I would like to automate it to the point where on the 30 day review date, it sends the employee survey to the employee. Once the employee is done with the survey, it is sent to myself and their manager. I would then need another trigger for it to send the survey (evaluation) to the supervisor to complete. Once it is complete, it will need to be sent to HR and their manager.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!