I'm getting an "Invalid Data Type" error
Hello,
I'm trying to count all rows (using a crosssheet reference) which have either "Discovery Call  Scheduling" or "Discovery Call  Scheduled" in the Sales Status column but am getting an "Invalid Data Type" error.
Thanks you.
Best Answer

What is the column type of the column containing your formula? If it's not a Text/Number column, you can get this error when trying to calculate a number value.
You're missing a close parentheses at the end of your formula. Notice how the opening blue parentheses does not have a matching blue at the end? You have to close off both the OR statement and the COUNTIF formula.
You could also try adding @cell = to your criteria:
=COUNTIF({Sales Status}, OR(@cell = "Discovery Call  Scheduling", @cell = "Discovery Call  Scheduled"))
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

What is the column type of the column containing your formula? If it's not a Text/Number column, you can get this error when trying to calculate a number value.
You're missing a close parentheses at the end of your formula. Notice how the opening blue parentheses does not have a matching blue at the end? You have to close off both the OR statement and the COUNTIF formula.
You could also try adding @cell = to your criteria:
=COUNTIF({Sales Status}, OR(@cell = "Discovery Call  Scheduling", @cell = "Discovery Call  Scheduled"))
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!