Join two fields, one with text format and the other with a date (which is a result of formula)



Help please.

I have a name in one cell [Service User] and a date in another [Visit Date] and wish to join them together to use as a lookup primary key value.

The date is extracted from a date/time using a formula which is working fine. However, using the + or join formula does not bring the date half of the concatenation back so the lookup finds no match. How can I get the date to behave as a text when it is extracted from the result of a formula please?

=JOIN([Service User]@row + [Visit Date]@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!