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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!