Using Actions to select upcoming years on a sheet

[mg_gsi_da]

I try to use the "Actions" function on a sheet to automatically select all future years.

It works well with a fixed value but not dynamic. Means the actual year should be evaluated like year(today())

This works as expected and selects all years >2021

I can also set a variable or formula but only for one year

This would set 2021

This of course doesn't work

let vGJAHR2 = year(Today())

Gives 2021 as well. Also =$(vGJAHR2) would result in 2021

How to modify the expression in the "Action" or the definition of the variable to get alle years selected >the actual year?

[mruehl · Accepted solution]

Hi,

Try this: '=Geschäftsjahr>=year(today())'
with simple apostrophes.

Schöne Grüße aus Hesse 😉

[mg_gsi_da]

Great. This works.

Die Hesse komme...

Danke Gruß Michael