Actual days passed based on % complete and submitted date



I am trying to write a formula that gives me the days that have passed between the time the percentage completed has been marked as 100% and the actual end date a task has been marked as complete. The caveat is that l don't know when the percentage complete is going to be marked, and the actual end date is to be manually selected from the calendar....Thanks!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!