Formula Help Please!

Lacey C

Hey there Smartsheet Community!

I'm fairly new to Smartsheet and have only been using it for about a year. I'm trying to build this formula and it keeps returning "0", which is not accurate. What am I doing wrong?

=COUNTIFS({Constat Range COMPANY}, "AHI", {Constat Range STATUS}, "closed", {Constat Range SCHEDULED CLOSING DATE}, >=DATE(2022, 12, 31), {Constat Range SCHEDULED CLOSING DATE}, <=DATE(2023 / 2 / 1))

Michael Culley

Your second date has slashes instead of commas.

Lacey C

Thank Michael. I fixed that but it did not fix the issue unfortunately.

Michael Culley

Hmmm...one thing you can do is try removing some of the arguments to see where the issue lies. Like just do countifs company AHI and Status closed.

If that works add on the dates etc etc. I suspect it's something to do with the dates but hard to say without looking at your sheets. Are you sure the dates fall between those dates?

Also, are the column types "date" on your sheet?

Lacey C

Good advice because this worked.

=COUNTIFS({Constat Range COMPANY}, "AHI", {Constat Range STATUS}, "closed")

The column in sheet that I'm referencing IS a date column. The column in the sheet where I'm building the formula is not a date formula because I'm not trying to configure a date but rather a sum.

Paul Newcome

How is the date column in your source sheet being populated?

Lacey C

Thanks for responding, Paul! I got it figured out!

Paul Newcome

Glad you were able to get it sorted.

What was the issue?