Formula that retains the last number when another field is updated

A Pisano

hi all,

I am building a formula off of the net working days between when a row as completed and today; which I have working. I want it to calculate the net days when it is in a certain project phase, which I have as well. The issue is that when the project phase changes, my formula value goes away. How do I update my formula to keep the last known value?

here is my current formula:

=IF([Project Phase]@row = "1 - Project Intake", NETWORKDAY(Created@row, TODAY()),

thanks in advance!

Ashley

Andrée Starå

https://community.smartsheet.com/discussion/138324/formula-that-retains-the-last-number-when-another-field-is-updated

Hi,

I hope you're well and safe!

Please have a look at my post below, which contains 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 day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!