Create a calculation in field
I would like to create a field where the values are dependent upon the data from another field. For example, I have a field named 'Sales Stage' with a drop down menu of entries such as 'qualified', 'solution presented', 'won', 'lost', etc. I would like to create another field called Probability that automatically assigns a percentage to each. For example when I click on 'qualified' in the Sales Stage field, i would like the data 10% to automatically appear in the Probability field for that same record. To continue, if I enter 'won' in the Sales Stage field, I would like the percentage to equal 100 in the Probability field for that same record.
Any assistance would be greatly appreciated.