Welcome!

Formula for counting overdue actions.

I would like to use a COUNTIFS formula to count the actions that are overdue. I've tried using the following formula, but get the error "#UNPARSEABLE" (without the quotation marks).

=Countifs([Due Date]:[Due Date],[Due Date}<=TODAY(),Status:Status,<>"Complete")

I have put together a similar formula for counting actions that will be due soon, with the same result.

=Countifs([Due Date]:[Due Date],(TODAY()-[Due Date])<8, Status:Status,<>"Complete")

What do I need to do to make these formulas work? Thanks for any insights you can offer!

Find more posts tagged with

Comments

Mike Wilday

Try this one:

=COUNTIFS([due date]:[due date], <TODAY(), status:status, <>"Complete")

=COUNTIFS([due date]:[due date], <TODAY(8), status:status, <>"Complete")

You don't need to add the column title to the condition.

Also, adding the 8 to Today will count everything coming in the next 8 days.

For additional help see:

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

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

Mikehud83

Mike, both formulas worked. Many thanks for your help!

Mike Wilday

You're welcome!

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic View Editing Role
Hi all, I want to utilize the Smartsheet Dynamic View. Considering the "editor access" type in smart sheet I wonder if the users are aimed to edit the view, should have the editor role? If I am not shared the file with them, will they stay as a Smartsheet user with viewer settings but are able to view the file? Thank you!
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Limiting Access to Folder and it's assets
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…