IFS Statement

Paul F
Paul F ✭✭
edited 12/09/19 in Formulas and Functions

I have the following equation I am trying to get working: =COUNTIFS({Range 1}, =1, {Range 2}, IFERROR(YEAR(@cell), 0) = 2018, {Range 2}, IFERROR(MONTH(@cell), 0) = January, {Range 3}, OR(@Cell="", @Cell="")) The equation has worked in the past without the or statement at the end.  It was once looking for one value here, now I want it to look for multiples.  Is this possible?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!