How to formulate the options depending on what user chooses

Two screenshots are shown above, first one is the top of the form and the second the last. What I want to do is:

  • When a specific FIRST two choices are made, the rest is determind

For example, when rats and mice and selected with a low client type, I know that the business needs to then choose the selling price of 140 (so I would like the 120 option to be greyed out)

How can I do this? Is there a specific formula I need to include in AppSheet?

0 1 74
1 REPLY 1

Top Labels in this Space