Automatically Added rows

Allison C

I have finally gotten my formulas to work (thank to this community) but have noticed they keep "breaking".

I figured out that when my sheet refreshes, and the rows are automatically added and the bottom of the sheet, the formula is looking at the blank cells and then I get an error message.

I have tried multiple way to stop the formula from counting the blank rows, and again, have been unsuccessful! :(

It is a ridiculously easy formula and I feel silly for asking help on this one but, I think Smartsheet fatigue has set in! LOL

My forumula:

=COUNTIF([Go Live Date]:[Go Live Date], YEARDAY(@cell) = 2022)

How do I keep this formula from counting the blank cells?

Thank you!

Paul Newcome

Try an IFERROR (also updating under the assumption you want YEAR instead of YEARDAY).

=COUNTIF([Go Live Date]:[Go Live Date], IFERROR(YEAR(@cell), 0) = 2022)