Dynamic trigger on Activate Sheet

[innashna]

Hi,

I need for each tab in the model on 'Activate Sheet ' put trigger for Solution_Leg_Status='In Progress'.  (As in the attached). Now we got requirement to activate this trigger only in case we don't have previous filters from previous sheets activated. How it can be implemented?

Thanks a lot.

Inna

[cwolf]

Create a dummy field for an alternative field selection:

TDummy:
LOAD 'In Progress' as Dummy AutoGenerate 1;

Now you can use followig expression for the Field in your trigger:

=if(GetSelectedCount(Solution_Leg_Status)=0 and Index(Concat(DISTINCT Solution_Leg_Status,','),'In Progress')>0,'Solution_Leg_Status','Dummy')

[Kushal_Chawda]

Which previous filter you want to look at because there could be many filters in that sheet and common to other sheet