Copy duration value to backup field and restore on specific status
I use a standard project template when beginning each project. As requirements are reviewed and tasks are not needed we mark the status N/A and zero out the duration. I'd like to be able copy the duration to a backup field and should the status change to anything other than N/A or Complete copy the backup duration back to the duration field. I hope this makes sense!
Appreciate any help on this!
Brent
Answers
-
@Brent.Taylor, you could make it happen with DataMesh -- do you have that?
-
I hope you're well and safe!
To add to Lucas's excellent advice/answer.
Please have a look at my post below with a method I developed.
More info:
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 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.
-
@Andrée Starå -- that's a handy post! I'm going to use that for sharing in the future. I found recently that you can use the same sheet as both the source and destination in DataMesh. That allows you to copy information from one cell to another on the same sheet. You can then create a helper column to use as your key column in DataMesh, with logic dictating when the information copies.
-
@Lucas Rayala, Thanks so much for your suggestion on Data Mesh. Unfortunately I don't have that option.
Brent
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!