Formula Operators Based On Cell Content

[Vince_Balsamo]

I’d like to create a formula that takes input from a table to determine it’s operators. So for instance, instead of saying X + Y it would say X thisrow.operator Y and a user could then easily change the operator to + - / * = > etc, by just changing that cell and not needing to know how the formula works. This is a simplified example for the purposes of the question.

I know this is not possible the way I have laid it out, but is it possible at all?

[Piet_Strydom]

HI Vince,

What you could do is the following:
In the formula column, write a (series?) of if statements:
If thisrow.operator = “+”
then X+Y,
If thisrow.operator = ""
then XY,

etc

Regards
Piet

[Scott_Collier-Weir]

Yup! Just use a switch() where the “expression” is a single select field containing the different operators

Then just have the different arguments match what the user selects.

So
If: select = x, then X * Y
If: select = >, then X > Y

[Vince_Balsamo]

That’s what I was afraid of. I have about 5 of these to right for 20 different criteria was hoping I could do a more literal swap but I guess not.