Formula to reference sheet auto ticket # with survey form link so that ticket id# follows process

cthurston

Hi! I was viewing How to Build a Ticket Intake Process That Actually Works - YouTube and at 9:45 minutes in, the presenter references a formula that will point to the ticket number on the intake sheet, connect it with the link to a survey, so that when the customer completes the survey and their info is input into the form, the ticket number is also automatically input so that the team can see which ticket number the customer is referencing when they complete the survey.

The formula looks something like this: =https://app.smartsheet.com/b/form/b4844d8b2d924192819c9806?TicketID=*+[Ticket#]@row

(numbers intentionally changed above for sample purposes)

but this isn't right and comes out as #UNPARSABLE - is anyone familiar with this formula or could direct me to where to find the correct formula?

Thank you!

Brent Wilson

@cthurston

I think you have the "symbols" wrong

"=https://app.smartsheet.com/b/form/b4844d8b2d924192819c9806?TicketID="+[Ticket#]@row

It is a Text string appended to a value Let me know if that works

Brent Wilson

@cthurston

I think you have the "symbols" wrong

"=https://app.smartsheet.com/b/form/b4844d8b2d924192819c9806?TicketID="+[Ticket#]@row

It is a Text string appended to a value Let me know if that works

cthurston

Thank you @Brent Wilson ! That did the trick. I think there must be something I'm missing on the other end as the ticket number isn't auto populating onto the survey sheet as hoped, but the formula itself works/is now showing as a formula and no error message. I'll keep digging for how to make it work all the way through, but thank you so much for the help!

JessBerry

@cthurston did you ever find out how to get the ticket number to populate? I am in the same spot where you left off!

Jess