Automatically Added rows

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!