How to concatenate two functions in a single cell

04/26/18 Edited 12/09/19

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.

Popular Tags:

Comments

Sign In or Register to comment.