I'm trying to set up a sheet that allows a user to select a time period and the comparison to be either to last year or to plan through the use of the listbox extension. I've had success with using this technique when I allow the user to select the time period and a specific metric but in the case of plans, the formula completely changes. See an example below
Goal is to create a formula that allows the user to change TimeFilter and Selector2 and new VersionFilter2
I was thinking a replacement could be included somehow that would have the VersionFilter2 select if it should grab the ActualFormula2 or the PlanFormula2 while still keeping the TimeFilter and Metric selector working. Any ideas?