Situation 1: Dollar amount as input
Add a column to the right on the sales rep input sheets so that they can manually input the dollar amount.
Situation 2: Selection from a list
Set up the parameters and the list pull downs for your reps.
- Add a column (D) to your 'Parameters' with dollar amount
- Input the values that your reps can select (D2 and below)
- Send the parameters to the individual rep sheets (see video at 2:35)
- On the individual rep sheets set up create your pull down lists in a new column based on the new parameters (see instructions)