Setting OnActivate Sheet Trigger on List Expression

[nadkalyan]

Hello ,

I have a list box with one expression that calculates number of Days based on 2 different dates as-

# of Days

if((((aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)) >= 0 and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate) <= 14),'0-14 Days', if((((aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)) >=15 and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate) <= 30),'15-30 Days', if((((aggr(max(LoadedDate), OpportunityNumber))-OpportunityCloseDate) >=31 and (aggr(max(LoadedDate), OpportunityNumber)-OpportunityCloseDate)<= 60),'31-60 Days','61+ Days')))

So this Expression gives me values as '0-14 Days', '15-30 Days','31-60 Days','61+ Days'

I would like to set the Trigger on the sheet based on "# of Days' Calculation so when sheet is activated, Select in Field option would be '0-14 Days' .

I was successful in setting the Triggers from Table Fields , but not sure how could i use List Box Expression field to acheive this.

Any insight into acheving this is very appreciated.

Thanks

Kalyan