Date Formula Issues, Metric sheet

megtro610

I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows?

I also would like to make a formula for a metric sheet that automatically updates as I add and delete years from my main sheet. What formula would I use for that part as well?

I've tried a few different options and keep getting the unparseable error.

Paul Newcome

If you are using a separate sheet, you will need to create each {Cross Sheet Reference} appropriately, and the formula would look something like this:

=COUNTIFS({Date Column}, IFERROR(YEAR(@cell), 0) = 2021)

Paul Newcome

If you are using a separate sheet, you will need to create each {Cross Sheet Reference} appropriately, and the formula would look something like this:

=COUNTIFS({Date Column}, IFERROR(YEAR(@cell), 0) = 2021)

megtro610

I just tried it and the populated number was 0, even though it should be about 4 or 5. do I need to reference something with at @cell part?

Paul Newcome

No. Assuming you set up your {Cross Sheet Reference} properly, that should be working. Exactly how is your date column being populated?