Hi! I’ve just discovered the formula column and need a little assistance.
I’m not sure if this is even a functionality of the formula column, but I’m looking to do the following;
A formula that can recognise the numerical value of a status - for example, ‘x’ = 90
Then do the sum “hours” x 90 (or whatever the numerical value of a status is).
In my mind, the formular would follow this path:
IF Status is “x”, MULTIPLY “hours” by "numerical value of “x”
Any help on this matter would be hugely beneficial!