Year and Quarter Selection

[sudhir243]

Hi,

If I select a specific year ( say 2015 or 2016) , the Quarter Q1 only should be selected by default.

Can you let me know how to solve this?

Thanks,

sk0243.

[sergio0592 · Accepted solution]

Hi,

Try with Document properties/Triggers and

=if(Year=2015 or Year=2016,'Q1')

[sudhir243]

Hi Sergio,

Thanks for the input.

Now it is working for me.

Regards,

sk0243