Can I create automated survey feedback to a user in Smartsheet
I'm new to using Smartsheet and I'm trying to design a survey with automated feedback to the user. I'm wondering if Smartsheet has the capability to do this. Here is an overview of what I'm trying to do.
I have created a survey that will be going to out to certain company branches. The survey has 10 sections with a pass/no pass criteria for each section. For each company branch, I require a minimum of 10 responses. After 10 responses have been completed, I would like to send some feedback back to the company branch. For each of the 10 sections of the survey, if they pass (according to my criteria), they get a congratulatory message, if they fail, they get several links to resources to enable them improve in that section.
How much of this can be fully automated, and how much of it does require me to do manually? Thanks in advance. Please let me know if you need additional details.
Help Article Resources
Check out the Formula Handbook template!