Adding Date to Deliverable Name

davidmartin95826 · 09/02/19

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 · 09/03/19

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 · 09/13/19

Thanks, that works

Adding Date to Deliverable Name

Comments

Categories