Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Counting overdue dates

edited 12/09/19 in Archived 2017 Posts


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.

Screen Shot 2017-07-31 at 09.14.23.png


This discussion has been closed.