What is wrong with my countifs data is between 2 dates formula?

toni.toni601 ✭✭✭✭
edited 01/03/23 in Smartsheet Basics

Hello team,

I'm trying to calculate my data if the status' end date is between 2 dates.

The formula I'm using is:

=COUNTIFS({Project Plan "Status"}, Item@row, {Project Plan "End Date"}, >[Date1]10, {Project Plan "End Date"}, <=[Date2]10, {Project Plan "Play Group"}, Item10)

In my external smartsheet project plan, I have the following columns:

Status = Disc, Des, P/S, Done

End Date = There is an end date for each status listed above

Play Group = the grouping in which each data point should be deployed

In this sheet, I'm looking to populate the 1/31/2023 column using the formula listed above. My column names for the dates are: Date1, Date2, Date3, Date4...etc...

The results I am receiving in all of the cells is 0.

My columns are set as date columns however I changed to "text/number" columns and still no values just 0.

any ideas?

Best Answer