Skip blank cells with YEAR function

I’m endeavoring a roll up sheet that will provide sum totals from a single row on a separate Planning Request sheet.

If the source sheet has all cells filled out, the formula seems to work fine:

=SUMIFS({Planning Request Range 2}, {Planning Request Range 1}, [Member]1, {Planning Request Range 3}, "Approved", {Planning Request Range 4}, YEAR(@cell) = YEAR(TODAY()))

 However, a date in the Range 4 column is blank, I get a #Invalid Data Type error in the roll up sheet.

I’m looking for a recommendation on how to skip blank cells when using the YEAR function as listed, or for a better way to parse out years… the goal will be to break out sums for 2020, 2021, etc

Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!