Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to set a trigger that will make an autoselection when acitvate the sheet.
The selection I want to make is all finished months current year. If I example enters the sheet todag (March 26) the correct answer should be 201201 and 201202.
Anyone who can help me?
/Magnus
Do you have a master calendar table in your load script? This will probably be the cleanest way to do what you want. In the master calendar you can then add a flag for complete months in current year and use a trigger on the sheet to select this flag when the sheet activates.
Cheers,
Emma
You can use 3 actions
1) "Selection in field" - and selects current month
2) "Selection Excluded"
3) "Selection in field" to select current year