Automatic Form Repsonse

Emma Haley

Hello,

I have a form in which staff submit their mileage journeys. In the smartsheet (not the form) I then have a column which totals all their journey miles to give the total mileage completed and the amount to be paid to them which the person submitting doesn't get to see.

Is it possible to set the sheet up so that an automatic notification is sent to the email address entered in the form showing the total mileage figure being claimed which is on the sheet? Or any other automated way that the cell containing the total mileage figure can be sent out?

 

Thanks,

Emma

 

Andrée Starå

Hi Emma,

Yes, it's possible but you have to get their email from a contact column or that they select from a contact list of predefined people. You can then configure a rule with Alerts & Actions to send an email to the submitter with the total mileage figure.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting