I was wondering if it is possible to create a list field with multiple options in a dropdown that when you select one of them it would auto-populate another field based on the selection.
If in one column I have a dropdown list with options like this:
And these options represent a number of something else like this:
T1 = 25
T2 = 50
T3 = 100
T4 = 150
Is it possible to have it so that in the drop down list column when you select T3 to have the second column linked so that it automatically fills in 100?
We would like to have the columns separate in order to be able to calculate totals and averages separately.