Can I use the 'created (date)' as start date for the GANTT?

Gottfried Reichl

Tried it but didn't see the date as a selection in the GANTT definition.

Is there eventually a work around?

Thanks,

Gottfried

Peter Goodwin

Yes, if you go to the " Edit Project Settings" on your Sheet, the gear cog in the top right corner of your sheet. Under the dependency setting tab, the "Date Range Display" options for "Start Date Column" and "End Date Column". Is where you can change what the Gantt will use. You can select any date column from your sheet.

Gottfried Reichl

Hi Peter,

thanks for the quick answer - I'm aware of the settings but I don't get the 'Created (Date)' as a possible selection.

There are only the fields 'Start Date' and 'Due Date' (my 2 date fields) but NOT 'Created (Date)'

Andrée Starå

Hi @Gottfried Reichl

I hope you're well and safe!

You can, but you need to add a so-called helper column to get the date from the Created column.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Gottfried Reichl

Hi @Andrée Starå

yes, that would be possible but how do I fill this field with the date?

Thank you,

Gottfried

Andrée Starå

@Gottfried Reichl

Happy to help!

I forgot to mention that it will only work if you're not using the Dependency feature.

Would that work?

Gottfried Reichl

@Andrée Starå

Unfortunately no, I need the dependencies.

Thanks for your help,

Gottfried

Andrée Starå

@Gottfried Reichl

You're more than welcome!

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, you could maybe use the Smartsheet API.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

David_Lewis