INVALID OPERATION
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"))))))
Answers

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

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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!