Help with a join formula to view two columns in calendar view

cmc ✭✭
edited 12/09/19 in Smartsheet Basics


I have several projects with many rows of information per project on one master sheet. I use conditional formatting to seperate/identify projects by colour. That colour coding applies to both grid and calendar view nicely. BUT I would like to combine a project code and task name in calendar view so I do not have to type the project code in every row of project. (attached is a sample).  Am I making this too complicated?! Is there no join formula that can join the project code + the task name and show both in calendar view?  Thanks!


Screen Shot 2019-04-09 at 2.29.58 PM.png

Screen Shot 2019-04-09 at 2.29.43 PM.png