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


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!