Adding Date to Deliverable Name

davidmartin95826

Hello,

I'm trying to add the End Date to the end of the Deliverable Name to appear as below.

Milestone to appear like:  "Sample Deliverable Name - [30/08/19]"

The End Date and Deliverable name are separate columns in the Workstream Plans.

I was thinking about using a formula to merge both columns and then hide that column, only to be used in the Smartsheet Report (Gantt). However, if new items are added to the Plans, without formula's being copied down it won't work.

Thanks again for your help,

David

 

Alejandra

Hi David,

You could accomplish this with the JOIN function. Also, as long as the formula autofill conditions are met —you’ll see your formula populate automatically.

davidmartin95826

Thanks, that works