Formula to find todays production

Techspan CT · 03/03/21

Hello Smartsheet Experts!

Im hoping someone can help out here... :) We are attempting to see if we can get a formula that will give us todays production based on the percent complete?

i.e. the project is worth $100 and on day we complete 20% so the value would be $20. Day 2 we progressed to 50% so our value for the days production is 50-20 = $30. Day 3 we complete the task 100% so our value for that day will be 100-50 = $50.

Is there any way this can be automated so the value would be written into a roll-up master sheet where we will be keeping a record of each day with a total value in production for each day throughout the year (possibly across multiple projects)?

Andrée Starå · 03/03/21

Hi @Techspan CT

I hope you're well and safe!

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 03/03/21