# Formula for counting how many people have signed in each month, referencing another sheet?

edited 03/13/23

I am trying to count how many people have signed in for each month referencing another sheet so that the number appears on my metrics sheet. The below is what I have at the moment but it isn't working:

Trying to find how many people signed into Yard A in January 2023:

=COUNTIFS({Yard A Date}, IFERROR(MONTH(@cell), 0) = 1, {Yard A Date}, IFERROR(YEAR(@cell), 0) = 2023, COUNTIFS({Signed in}, [Primary Column]:[Primary Column], @cell = "Signed in"))

#UNPARSEABLE

I have also tried:

=COUNTIFS({Yard A Date}, IFERROR(MONTH(@cell), 0) = 1, {Yard A Date}, IFERROR(YEAR(@cell), 0) = 2023, {Signed in}, @cell = "isnotblank")

returning a value of 0, which is incorrect it should be 254

I also plan to add more yards to this formula, I figure once I've got it right with one I can + and duplicate for the others.

Can anyone help with this formula I think its the referencing another sheet is stuffing me up here?

• Have also tried:

=COUNTIFS({Yard A Date}, IFERROR(MONTH(@cell), 0) = 1, {Yard A Date}, IFERROR(YEAR(@cell), 0) = 2023, {Signed in}, NOT(ISBLANK(@cell)))

But its also returning a value of 0

• ✭✭✭✭✭✭

How exactly is your {Yard A Date} range being populated, and do you have the column formatted as a date type column?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!