This content has been marked as final. Show 3 replies
I have a sheet with various tables and charts with a List Box containing all Dates from a date field (DATE) in one of my loaded tables.
I use the list box to select dates for the table / chart displays.
How can I arrange so that the latest date in the date field is automatically selected upon opening the file.
I have checked the forums and tried setting a trigger On Open>Actions>Select in Field with Field = DATE and Search String = =date(Max(DATE))
It does not work.