nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Counts with status and Date

CEidel

Hi,

I'm new to Smartsheet and I'm having some issues with one of my formulas. I want to get a count of everything where the Status = Completed and then the following:

Due Date = Completed Date
Due Date > Completed Date
Due Date < Completed Date

Find more posts tagged with

Formulas

Comments

Paul Newcome

You will need to use a helper column to establish how the dates compare.

You can then use a COUNTIFS function to include the two sets of range/criteria.

CEidel

thank you!

Paul Newcome

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Issue with Email Notifications via Workflow Automation
Dear Smart Community, I am experiencing an issue with a specific email ID that is not receiving notifications triggered through workflow automation. However, the user is able to receive emails when I send an update request manually. I have tested several scenarios in coordination with the IT team. For example, when…
Form adding rows to smartsheet
I have a form adding new rows to my smartsheet but it doesnt add the next number in the primary key, is there a way to do this?
Adding Months to the Same Column
I am trying to setup a sheet that can project dates decades into the future. I want a formula that can look the date in the row above, check to see if it's annual or quarterly, then add the appropriate number of months to each row. While testing the formulas, I keep getting stuck on how to add one year (12 months) to each…