INVALID OPERATION

Kegan Copas

Hi all,

I am trying to do a very basic formula to create a Score of two columns but am receiving the error #INVALID OPERATION. Is this due to the source columns also being built of a formula?

Kegan

=IF(ISBLANK(Probability@row), "", IF(Probability@row = "Almost Certain", "5", IF(Probability@row = "Likely", "4", IF(Probability@row = "Possible", "3", IF(Probability@row = "Unlikely", "2", IF(Probability@row = "Rare", "1"))))))

=IF(ISBLANK(Impact@row), "", IF(Impact@row = "Severe", "5", IF(Impact@row = "Major", "4", IF(Impact@row = "Serious", "3", IF(Impact@row = "Important", "2", IF(Impact@row = "Minor", "1"))))))

Kegan Copas

Finally worked it out, you need to use the VALUE prefix

Andrée Starå

Hi @Kegan Copas

I hope you're well and safe!

Yes, you can use VALUE, but I'd recommend removing the " " around the numbers because they make Smartsheet read the numbers as text, and that's why VALUE works. Removing the " " should work without adding the VALUE function.

Make sense?

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!