How to best create a ref Column with custom text message while also including column data?

[Austin_Samagam]

So I’ve got a ref column and i’m using a custom text in the Formula, but it does not seem to grab the data from my spreadsheet.

Basically i’m stating this in the Formula:

"Here is your assigned pickup:

Name: [Name],
Adults:[Adults],
Kids:[Kids],
Phone Number: [Ph#] "

When I test the formula, the expression result is the same as my formula, the column fields are not populated with the correct data like the actual names and ph#.

What am i missing?

[MultiTech · Accepted solution]

Austin_Samagam:

"Here is your assigned pickup:

Name: [Name],
Adults:[Adults],
Kids:[Kids],
Phone Number: [Ph#] "

Assuming this is your formula, try this instead:

concatenate("Here is your assigned pickup:

Name: ", [Name], "
Adults: ", [Adults], "
Kids: ", [Kids], "
Phone Number: ", [Ph#]
)

---

Just FYI, it’s not suggested that you have special characters in your column names; it’s okay most of the time, but when you get into workflow email templates and things they can cause havoc. (Talking about the # in [Ph#])

---

Ending question:

Austin_Samagam:

So I’ve got a ref column and i’m using a custom text in the Formula

what do you mean by this???

[Austin_Samagam]

This worked! Thank you!

You can ignore the …‘custom text…’ in my original post. Its not as relevant as I thought.

[MultiTech]

Happy it worked out