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.
Tags:
Comments
-
Hi Soumya,
The Function you will need is =JOIN - this is SS 'concatenate' solution.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!