Change the value of specific column selection

Hello there,
I’m trying to accomplish something that I don’t know if it’s possible. You guys could tell me. I’m trying to change the data of a specific column in one of my tables. I have a column which is yes or no, if the answer is yes, the user will need to input a number in another column, following by specifying which column they want to change the value of with the value of the number they just input. They will need to select which column they need to change the value of from a range of a specific columns in the same table.

note: the range of columns from which they will need to pick, they have a formula that equals to the value of another column.

Is this possible?

Thank you for any help guys! I’m really stuck right now throwing flying kicks at the moment to see if I land one. lol

Solved Solved
0 2 238
1 ACCEPTED SOLUTION

View solution in original post

2 REPLIES 2

Thanks @Marc_Dillon. After carefully reviewing all these links. I was able to construct the formula needed for this feature.

Top Labels in this Space