action on document

[tizianacaem]

Hi to everybody,

I want to set an action on the opening of the document, that select at the same time YEAR= Year (today()) AND YEAR =Year (today()-1)
Any ideas?

thks

Tiziana

[#2]

Hi Tiziana,

Why Action?

You can also Set in the Menu-> clear-> Set clearstate to these Years you mentioned. May be I am understanding you wrong.

Regards

sravan

[erichshiino · Accepted solution]

Go to settings -> document properties -> triggers -> OnOpen -> Add Action

There, Add Selection in Field

Field = Year

Seach String

='(' & YEAR(TODAY()) & '|' & (YEAR(TODAY())-1) & ')'

(including the whole line above)

[tizianacaem]

I did not explained well, sorry.

I mean that I want that these value of years are selected during the opening of the sheet, and not clear.

Regards

Tiziana

[erichshiino]

You mentioned 'Open the document' in the first post. If you need to make this on the sheet, you can go to sheet properties ->Triggers and do the same I mentioned before. The attachment can help

[tizianacaem]

thnk you.. it working correctly!!

Regards

Tiziana