Calculate number of days a task is later than forecast end date
Dan Harris
✭✭✭✭✭
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
-
Hi Dan,
Try this formula in your [Complete working days late] column,
=IF([date %]@row < 1, TODAY() - [forecast end]@row, "-")
Hope this helps,
Mathieu | Workflow Consultant
info@evolytion.com
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!