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!
Answers
-
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)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!