Copy Value only and not the function
Hi,
My second column has an IF function based on the first column that returns one of 4 possible values. I then need to preform another function (basic division) in a 3rd column based on the result in the second column. However, when I enter the function it returns a #INVALID OPERATION.
Is there a way to just extract the value from the second column sans function? Or do I need add some sort of helper column?
Thank you,
Bob
Best Answer

Hi,
I have tried to do what you are trying to tell me:
Column 3: =IF([BUSES ONSITE]@row = 0, 42, IF([BUSES ONSITE]@row = 1, 34, IF([BUSES ONSITE]@row = 2, 28, IF([BUSES ONSITE]@row = 3, 20))))
I left out all the inverted commas in the formula above.
Column 4: =[OCCUPIED PARKING SPACES]@row / CALCULATION@row
Answers

Here is my test that works:
First column: Programme Manager
Second column: Point score
Third column: Points devided by 2
Second column formula: =IF([Programme Manager]@row = "Anton Kriel", 5, IF([Programme Manager]@row = "Riaan du Preez", 4, IF([Programme Manager]@row = "Dirk Theart", 2, 0)))
Third column formula: =[Point score]@row / 2
My results in my third column:
For Anton Kriel = 2.5
For Riaan du Preez = 2
For Dirk Theart = 1

Hi,
Thank you for the quick response. This did not work for me. I need to divide a value in a column by the resulting value from the IF formula column. Basically I have:
Column One: Buses Onsite
Column Two: Occupied Parking Spaces
Column Three: Calculation based on the number of buses =IF([BUSES ONSITE]@row = 0, "42", IF([BUSES ONSITE]@row = 1, "34", IF([BUSES ONSITE]@row = 2, "28", IF([BUSES ONSITE]@row = 3, "20"))))
Column Four: Column Two/Column Three
Still returns an #INVALID OPERATION
It doesn't seem to like dividing by the result of a function. Easy in Excel but I am new to Smartsheet.
Any suggestions?

Hi,
I have tried to do what you are trying to tell me:
Column 3: =IF([BUSES ONSITE]@row = 0, 42, IF([BUSES ONSITE]@row = 1, 34, IF([BUSES ONSITE]@row = 2, 28, IF([BUSES ONSITE]@row = 3, 20))))
I left out all the inverted commas in the formula above.
Column 4: =[OCCUPIED PARKING SPACES]@row / CALCULATION@row

Dear Bob,
please check the column type and try to write 42 instead of "42" in your formula.
Best Regards
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Thank you both!!!! I removed the commas and it worked.
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives