Any way to automate a copy/paste into a date column?
In our schedule file, we have 3 date columns: Baseline Finish Date, Planned Finish Date, and Actual Finish Date.
The Baseline Finish Date is what is originally planned but may not always be accurate, so we use the Planned Finish Date to drive up-to-date planning and reporting. This column is linked out to the high-level overviews at both project and portfolio levels making this data critical.
I had previously used a simple =[Baseline Finish Date]@row formula to copy in the date to the Planned Finish Date column, but have found that cells with formulas cannot be updated from a report.
This is where I started investigating if I could set up an automation for when the Baseline Finish Date is changed (one time only at the start of a project) that Baseline Finish Date will be copied into the Planned Finish Date column.
I am not seeing an automation option to complete this as desired. Can anyone assist or provide a creative solution as a work around?
Thanks in Advance!
Answers
-
Hi @KevinPlut
I hope you're well and safe!
Have you explored using the Baseline feature?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!