Can I use the 'created (date)' as start date for the GANTT?
Tried it but didn't see the date as a selection in the GANTT definition.
Is there eventually a work around?
Thanks,
Gottfried
Answers
-
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.
-
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)'
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
yes, that would be possible but how do I fill this field with the date?
Thank you,
Gottfried
-
Happy to help!
I forgot to mention that it will only work if you're not using the Dependency feature.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives