Cross-sheet COUNTIF Formula w/in a specific date range

Andrea Mayer

Hi all,

Looking for some help on a formula I have been working on. I am trying to count the number of requests that have been submitted between a specific timeframe (2/14/22-3/18/22). The date column I am looking at is in another sheet (Date OnlyN).

=COUNTIFS({Date OnlyN}, >=DATE(2022, 02, 14), {Date OnlyN}, <=DATE(2022, 03, 18)))

Any help is appreciated. TIA!

Andrea

Jeff Reisman

@Andrea Mayer

What error are you getting when you try that formula? Error messages help determine what the problem is. Just from the start it looks like you have an extra end parentheses at the end. Make sure your first open parentheses and last end parentheses are the same color.

Jeff Reisman

@Andrea Mayer

What error are you getting when you try that formula? Error messages help determine what the problem is. Just from the start it looks like you have an extra end parentheses at the end. Make sure your first open parentheses and last end parentheses are the same color.

Andrea Mayer

@Jeff Reisman

I was receiving the "UNPARSEABLE" error. I am almost certain that Smartsheet had added that extra parenthesis in at some point. I noticed it was not in color and tried to delete it and it was added back automatically. Not sure why. However, when I tried to remove it after reading your reply - the formula worked!

=COUNTIFS({Date OnlyN}, >=DATE(2022, 02, 14), {Date OnlyN}, <=DATE(2022, 03, 18))

Thank you!

Jeff Reisman

@Andrea Mayer Must be that magic I.T. Guy voodoo! Glad it's working now.