Back dating
Hello, I am looking for instructions on how to get smartsheet to backdate.
For example, I have a due date for a project and I want it to create auto create internal dates based off that.
Essentially the end of the project drives the internal deadlines.
I am set up to know how long each step takes in days
and I was using Predecessors.
Thoughts?
Comments
-
Total stab in the dark, but is this what you're trying to do?
You can ignore Row 3 since it's from one of my templates.
The basic idea is to use predecessors and have the first task have a finish to start dependency on the last task with a negative float of the total of all of the task durations.
I had to back into the start date of the last task using the scheduled finish date and duration, but everything else calculated.
Wonder if something like this is even sustainable for a full project plan?
-
Hi,
There is an excellent Template in the Solution Center called: Project with Hard Deadline and Gantt.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives