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