Hello,
I'm attempting to create a trigger on sheet activate to select the Max CalendarQuarterYear, which in the data is formated as 'Q1-2016'. When I try adding the field CalendarQuarterYear and Search String as Max(CalendarQuarterYear), or MaxString(CalendarQuarterYear) it doesn't work correctly.
When I add MaxString(CalendarQuarterYear) to a textbox to see the result it doesn't give the latest quarter and year in the data set it gives the selected since the field is always one selected.
