Count of rows created on 2 sheets within a certain time frame.

Hi everyone!

I would like to get the count of rows created on 2 sheets within a certain time frame.

I created a formula (1) to get the count of one sheet and it worked. I tried to add the other sheet to the formula (2) but I got an error message (3).

  1. =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5, {Created 2}, IFERROR(YEAR2cell), 0) = 2024) = 11
  2. =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5,{Created 2}, IFERROR(YEAR(@cell), 0) = 2024, {Created}, IFERROR(MONTH(@cell), 0)= 5, {Created}, IFERROR(YEAR(@cell), 0) = 2024)
  3. #INCORRECT ARGUMENT SET

Can anyone help?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!