Formula to find todays production

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)?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!