Ignoring blank cells in If formula

mpajuelo ✭✭
edited 12/07/23 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!