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?
Please sign in to leave a comment.