"Invalid Operation
Why am I getting and "Invalid Operation on a simple formula that I have used many times
Best Answer

Thank you that worked, but for some reason the column wont switch to a %, so I just made a helper column one with the % and one for the formula that I will hide.
Answers

Hi Shannon,
I'm not sure if the formula is looking to sum the two, or multiply?
If Sum, I'd try
=SUM([Structure Value]@row, [Win Prob %]@row)
If multiply, I'd try
= [Structure Value]@row * [Win Prob %]@row
Hope this helps?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile  Open to work

The formula seems to be correct as it works on other sheets, I can seem to figure out what is wrong with this particular sheet

This error can occur if the formula is reading one of the cells as text instead of numerical. How is your percentage calculated? Can you paste that formula here?
Try wrapping a VALUE function around one or both cells:
= VALUE([Structure Value]@row) * VALUE([Win Prob %]@row)
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
I tried the VALUE, I get the #INVALID VALUE
Below is how I get my %, I think this is the issue, I tried a dummy colum and manually entered the % and it works. But I need it to work from the {Win Proability %} column

Yes, this is exactly where the issue is coming from. Using "11%" in your formula tells the cell that 11% is a text value.
Try using the decimal value instead, like so:
=IF(Rank@row = "B", 0.11
Then you can add the % formatting to the entire column from the top toolbar instead. Let me know if this works!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Thank you that worked, but for some reason the column wont switch to a %, so I just made a helper column one with the % and one for the formula that I will hide.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 416 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!