I have a priority rating field, which I would like to auto-populate based on the answer to some previous choice questions. Can I do this with 'If' rules, or something else?
If field 1=x and field 2=y, then auto-populate field 3 with z, for example.
1. Is this a calculation? or is more like a lookup matrix? For instance Probability and Impact can give me a Risk rating. Probability = 2 and Impact = 3 then Risk rating = 2 x 3 = 6. This can be done with a calculated field.
2. If it is a lookup, i.e. Car = Audi and Model = A4 then Price = $20,000. For example 2, you can have a list on the site and use the lookup function to go and fetch the Price based on Car and Model selected.
Does this help? Or can you explain the example in a bit more detail?