Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
='$(=YEAR(TODAY()));$(=YEAR(TODAY()) - 1)'
='$(=YEAR(TODAY()));$(=YEAR(TODAY()) - 1)'
@Mark_Winter you are a genius! 🙂
I wouldn't go that far but I'm happy to have eased your suffering, friend 😸