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

Hi,

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.


Thanks


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

3/8/20 99% 2

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!