2 followers Follow

Calculating using IF/THEN

I am new to PODIO and I am trying to create a read/view only numerical field based on a calculation that uses an if/then statement.


Quantity is a numerical input

Product is a dropdown list and each product has a numerical value

Product List | Option 1, Option 2, Option 3

Numerical Value | Option 1 = 295, Option 2 = 305, Option 3 = 310

The numerical value would be an "always hidden" field...ideally since i just want it to calculate behind the scenes

So....the formula would be something like this....


Total (automated read/view only calculation) = IF (Product selected = "Option 1") Then ("Numerical Value for Option 1" x Quantity)


Is this possible?

Andrew Curtis

Please sign in to leave a comment.