Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Feature Request - Ability to Email locked fields in the auto-response
We are attempting to use Smartsheet to aggregate some of our quality data. Users score customer interactions and will utilize a web form to populate a Smartsheet. The sheet contains formulas that calculate the actual scores (in a few categories). We need a way to get the results to the evaluator relatively quickly so they can share the score and use the output for coaching the rep.
I have enabled the "email confirmation" and as long as I include the fields with the formulas in the form, the user will get a copy of all their entries AND the calculated score. However, that means I have to include a field in the form that I really don't want them to fill in.
In a perfect world, there would be an option to include locked fields in the email confirmation.
Alternatively, if there was a way to format a report to look more like the email confirmation, we could bundle those up and send those reports out daily.