Calculate number of days a task is later than forecast end date


Can somebody help?

I need to add a column that calculates how many days late tasks less than 100% complete are compared to today see below example, basically need a formula that calculates the 'working days late' column.


forecast end date % Complete working days late (based on todays date)

3/8/20 99% 2



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!