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
=COUNTIF([Go Live Date]:[Go Live Date], YEARDAY(@cell) = 2022)
How do I keep this formula from counting the blank cells?
Help Article Resources
Check out the Formula Handbook template!