Multiple selected values in Action with =YEAR(TODAY())

[MindaugasBacius]

Hei community,

I am struggling with a simple task. I need to select multiple values in the sheet Action Select values in a field.

I need to use like =YEAR(TODAY()) and =YEAR(TODAY()) - 1.

It seems that the formula is OK, but the values do not select.

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

I have tried many variations but nothing helped. Any ideas on how could I accomplish this?

Thank you!

[Mark_Winter · Accepted solution]

='$(=YEAR(TODAY()));$(=YEAR(TODAY()) - 1)'

[MindaugasBacius]

@Mark_Winter you are a genius! 🙂

[Mark_Winter]

I wouldn't go that far but I'm happy to have eased your suffering, friend 😸