Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
Which previous filter you want to look at because there could be many filters in that sheet and common to other sheet