How to show # Days Overdue only if the task is not complete

vishalpandey

Hello Community,
So I have a sheet with different columns
I am using three columns % Complete, End Date and # Days Overdue

I want the # Days Overdue Column to show the number of days the task is overdue only if the task is not complete i.e. the % is less than 100%

The current formula I am using is

=IF([% Complete]@row = "100%", " ", TODAY() - [Finish Date]@row)

This still gives me the days even if the % complete is 100%.

What am I doing wrong here?

TIA

Andrée Starå

https://community.smartsheet.com/discussion/121084/how-to-show-days-overdue-only-if-the-task-is-not-complete

Hi,

I hope you're well and safe!

Try something like this.

=IF([% Complete]@row = 1, "", TODAY() - [Finish Date]@row)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!