Any idea why when one of my criteria is from Letter 'A' through 'M' I'm getting 'INVALID DATA TYPE'

Options

but not when the criteria is N?

This is working OK,

=COUNTIFS({BIN}, "N", {Status}, "Qualified Occupied", {Move Out}, MONTH(@cell) = MONTH(Date@row), {Move Out}, YEAR(@cell) = YEAR(Date@row))

But when I replace N with A i get an error

=COUNTIFS({BIN}, "A", {Status}, "Qualified Occupied", {Move Out}, MONTH(@cell) = MONTH(Date@row), {Move Out}, YEAR(@cell) = YEAR(Date@row))

Column BIN has letters A - U.


...

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!