Default current fiscal year and month in current selection on active sheet

[#1]

Hi All,

I am trying to set a default current fiscal year and month in my current selection for sheet.

Any help would be appreciated.

Thanks!!

[datagrrl]

It works for me. Look at the Test sheet.

[#3]

Even I see that variable in input box but not in Current selection and data is not refreshed accordingly..

[datagrrl]

I didn't have an input box or current selections box on the example I uploaded.

I added a Current Selections Box and removed the text box that was just showing the result of the Fiscal Year variable.

I added triggers to both sheets, the Main is Current Year and the Test is Fiscal year.

If this isn't what you were asking for I think I misunderstood you.

[#5]

For some reason I don't see the default current selection in your file. But that's' what am looking for.

Do you see by default fiscal year in you file??

[datagrrl]

I implemented the default using the Sheet Trigger.

[#7]

Perfect!!!

That's what am looking for.. but y isn't working me ??

[datagrrl]

Could it be a version thing? I am using 11.2.

You aren't forgetting the = sign in front of the variable in the search string are you? I have done that before.

[#9]

Version 11.20.12347.0

[#10]

No am not, I do have '='

[#11]

The only difference I see is I don't have an '=' in variable definition. Where did you define vFiscalYear in??