Can I have one field look up the input in another field and provide a value specific to the input selected?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

"To start with I'm a newbie so detailed help is appreciated. 

I have a Material field that is text multiple choice with selectable values DFM or DFR etc. I have a Cost field that is numeric formula that I would like to have a value associated with what is selected from the material field. 

So if DFM is selected in the Material field the value in the Cost field would be $100 or if DFR is selceted the value would be $120. ?

Photo of rob

rob

  • 0 Points

Posted 4 years ago

  • 0
  • 1
You could have a field of type formula-numeric with the formula of

Case([Material type],

"DFM", 100,

"DFR", 120,

"ABC", 999)

It could also be written like

IF(

[Material Type]= "DFM", 100,

[Material Type]="DFR", 120,

[Material Type]="ABC",999)
Photo of rob

rob

  • 0 Points
Worked like a charm, thanks for the quick response.