Why am I getting an INVALID DATA TYPE error?

Options

Here is my formula, which references another sheet. All referenced columns are the same type (drop-down)

=COUNTIFS({Lead Category}, OR(@cell = "Lite Upgrade", "@cell =New Lite Site"), {Sales Type}, "New Deployment", {Sales Tier}, "Experiencia")


Thanks for your help!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!