ticket reference - smartsheet form

amar1699

Hi,

Is it possible to create an automated ticket reference in smartsheet form i.e. when a user completes a form, can smartsheet generate a ticket reference?

Many thanks

Andrée Starå

https://community.smartsheet.com/discussion/130735/ticket-reference-smartsheet-form

Hi,

I hope you're well and safe!

Yes, you can generate a ticket number automatically after submitting the form. Then, you can trigger an alert for the submitter with confirmation, including the ticket number.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

amar1699

Hi Andrée,

Many thanks for your response,

How could I achieve those steps that you have outlined?

Kindest regards

 

Andrée Starå

https://community.smartsheet.com/discussion/comment/453650#Comment_453650

Happy to help!

You'd first add an auto number column to the sheet. Then, you need to know who the submitter is, so you also need to either add an email column or set the form so they need to be logged in to Smartsheet to be able to access it. You'd then either use the email column or add the created by column to get the email and trigger an alert when the row from the form is added to the sheet.

Have you explored the available templates in the Solution Center?

Make sense?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!