Ignoring blank cells in If formula
How do I have a formula ignore a blank cell in a column and still produce the correct outcome?
The "Rabies" column will always be filled but the other 2 columns will alternate as to which one is filled. If any of the dates is expired I would like it to show as "Vaccination due".
Best Answer
-
Hi @mpajuelo
Would this work for you instead?
=IF(TODAY() > MIN(Rabies@row, [DA2PP]@row, FVRCP@row), "Vaccine Due", "Up to date")
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Answers
-
Hi @mpajuelo
Would this work for you instead?
=IF(TODAY() > MIN(Rabies@row, [DA2PP]@row, FVRCP@row), "Vaccine Due", "Up to date")
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
-
Works, thank you!
-
Awesome!
Glad I could help.
Stay safe.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!