Hi guys I am making a SP 2013 site and am currently creating columns...
I have a drop down column (Circuit Type) , four text fields (Num1, Num2, Num3, Num 4) and a calculated column (Loss).
The Circuit Type dropdown has 5 different values. (ISDN, HDSL, HDSL2, HDSL4, Other).
The user choices a value and types a number in each text field and then the calculation appears....
but if user clicks on Circuit Type "ISDN" the calculation for "LOSS" will be Num1+Num2
but if the user clicks Circuit Type "HDSL" the calculation for "LOSS" will be different, same for the each of the different circuit type values..
How would I go about the certain calculation to happen depending on what Circuit Type the user chooses?
Im thinking of using designer workflow in SP Designer 2013, but not sure how to go about that.
Any help or suggestions will be much appreciated.. If you need more details I will reply back quickly.