Copy duration value to backup field and restore on specific status

Brent.Taylor

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

Lucas Rayala

@Brent.Taylor, you could make it happen with DataMesh -- do you have that?

Andrée Starå

Hi @Brent.Taylor

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: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

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!

Lucas Rayala

@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.

Brent.Taylor

@Lucas Rayala, Thanks so much for your suggestion on Data Mesh. Unfortunately I don't have that option.

Brent

Brent.Taylor

@Andrée Starå, I would love to learn more about the your solution.

Regards,

Brent