Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
In trying to use Smart Sheet as a way to track applicants, and even use a form as an application, I'd like to be able to notify applicants that did NOT get the job that they didn't get the job.
Is this even possible if I collect email addresses?
Hi Tyler,
Yes it's possible and a great use of Smartsheet.Ask the applicants to provide their e-mail address in the form. There are a few different ways you can handle this process.
My recommendation would be to connect thru Smartsheet Merge with Google Docs and have a template for the answer that will be sent to the applicant as an pdf.https://www.smartsheet.com/apps/google-docs-smartsheet-merge
Would that work? I have a few other alternatives if it doesn't.
I hope this helps you!
Best,
Andrée
Andree's solution should work, but you could also set up a notification with specific rules to fire an email when a field is changed.
For instance, you could set up a Hiring Status column with a dropdown including Hired, 1st Interview, 2nd Interview, Did not pass Interview.
And then on your notification when a column is changed to "Did not pass Interview" then send an email.
Here is some more information about setting up notifications: https://www.smartsheet.com/blog/new-in-smartsheet-advanced-notifications
