How to concatenate two functions in a single cell

Soumya

I want to concatenate two functions in a single cell and populate the values in the same cell separated by coma.In excel we do the same by =H65-K65 &","& I65-L65 but in smartsheet when I try the same like =[Next month Proposed date for First]2 - [Assigned date of First PCT after Finetuning]2 &","& [Second PCT]2-[Assigned 2nd PCT]2 it is showing UNPARSEABLE.Please let me know the syntax for concatenating.I also tried =[Next month Proposed date for First]2 - [Assigned date of First PCT after Finetuning]2 +","+ [Second PCT]2-[Assigned 2nd PCT]2 but still it is showing as UNPARSEABLE.

[email protected]

Hi Soumya,

The Function you will need is =JOIN - this is SS 'concatenate' solution.