Jun 14 2019 09:05 AM - edited Jun 14 2019 09:06 AM
Jun 14 2019 10:56 AM - edited Jun 14 2019 11:01 AM
Jun 14 2019 11:43 AM
Jun 14 2019 11:57 AM
Jun 14 2019 12:49 PM
Jun 15 2019 12:48 AM - edited Jun 15 2019 12:49 AM
In the attached file, I have 2 sets of formulas for the Source box. The first allows you to select "Opportunity" (if applicable), then Other Options, like this:
=(IF(V7*(W7=""),Option1,Option2)
The second allows you to select All Options (if applicable); otherwise, it only allows you to select All Other Options, excluding "Opportunity", like this:
=(IF(V9,Options,Option2)
Note the following names defined in Sheet2:
Name | Formula |
Option1 | =Sheet2!$A$2 |
Option2 | =Sheet2!$A$3:$A$9 |
Options | =Sheet2!$A$2:$A$9 |