topic Using Actions to select upcoming years on a sheet in App Development

Using Actions to select upcoming years on a sheet

mg_gsi_da — Tue, 27 Jul 2021 07:34:48 GMT

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?

ManuelRühl — Tue, 27 Jul 2021 08:15:05 GMT

Hi,

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

Schöne Grüße aus Hesse 😉

mg_gsi_da — Tue, 27 Jul 2021 08:21:23 GMT

Great. This works.

Die Hesse komme...

Danke Gruß Michael