Counting overdue dates

James_stil

Hi,

I'm trying to include a formula that counts overdue dates (by inputting 1 in another column and then using SUM). It works but if the date is left blank it still includes '1'.

The reason I have some black is it's the only way I've found to 'check it off' as sent.

Any suggestions greatly appreciated.

J. Craig Williams

James_stil,

You could add a "done" or "completed" column to check it off.

Without that, there are still some ways to tackle this.

Your formula could be:

=IF(ISBLANK([Quote Due]5),0,IF([Quote Due]5 < TODAY(),1,0))

or you could bypass this formula all together and use COUNTIFS() where you summing the 1's.

https://help.smartsheet.com/function/countifs

Craig

(Note: I did not test the formula)