Post

1 follower Follow
0
Avatar

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.

Example:

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.