Counts with status and Date

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

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet