I'm getting an "Invalid Data Type" error

Options

Hello,

I'm trying to count all rows (using a cross-sheet 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.

Tags:

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓
    Options

    @deb_63_hydracor

    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

    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

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓
    Options

    @deb_63_hydracor

    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

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!