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

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!