Percentage (%) complete formula - cancellation date

edited 03/30/20 in Formulas and Functions


Due to COVID 19 we have had to cancel some courses up till the end of June.

I need help to make a column with a formula to calculate the percentage of the course that was complete at time of course cancellation (any date between start and end date) given columns with the start date, end date and cancellation date.

Any help gratefully appreciated, thanks in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!