Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Could someone please advise me on how I set a trigger to select current year in the table 'YearAsOf' when opening a tab?
I know how to get to the trigger option but unsure what to select / add from here.
Many thanks.
John
Dear go to sheet properties >>Triggers>>Edit Actions>> and follow attachment
triggers--- edit action on open.
Action ...Select in field
Field= (DATE)
Searching Strign
= Year(today())
Regards
Dear go to sheet properties >>Triggers>>Edit Actions>> and follow attachment