Cross Sheet Reference Formula


I am trying to write a cross reference sheet formula to count MTD dates in a column using this formula I found here but it is not working. Thoughts?

=COUNTIFS({Andee Metrics Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0 = MONTH(TODAY()))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!