I have multiple options from a field that are then being converted into a number value. I need there to be a sequential order of starting with one cell and executing an if statement. However, if that first one is not true, then it moves on to the next cell which would have multiple options (of the opportunity stage) that will return a number value for the stage of the opportunity.
To simplify:
If yes in the first cell, moves on to the next cell to determine the stage value of the opportunity. If no in the first cell, then the second level of inquiry is disregarded and a stage value is returned.
User | Count |
---|---|
18 | |
13 | |
8 | |
2 | |
2 |