Calculating A Formula Question

Hello Smartsheets Community:

Does anyone know why I would be getting a #INVALID when calculating a formula in a column that references two other columns with formulas in it? I thought you could calculate a formula in a column that references other columns with formulas in it? Is that not the case? Or, am I using the wrong formula? Any help would be greatly appreciated.

Best,

Anthony D'Ambrosio



Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @Anthony D'Ambrosio

    Your [High/Med/Low Rank] column is the issue.

    The formula there is not creating a number it is adding a string "5". You should be able to just change that formula to 5, 1, and 3 (without the quotation marks), and it would remove the issue with the other column.

Answers

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @Anthony D'Ambrosio

    Your [High/Med/Low Rank] column is the issue.

    The formula there is not creating a number it is adding a string "5". You should be able to just change that formula to 5, 1, and 3 (without the quotation marks), and it would remove the issue with the other column.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!