I have a question regarding dynamic bookmarks. I want to create a bookmark that understands the following query. If there is already exactly one selection for the Year field, then keep the bookmark. Otherwise, select the current year. This bookmark should help consumers avoid mistakes when jumping between different worksheets.
I have now already created a dynamic bookmark, but I can't manage:
- to write '2022' as year(today()) (see also marked expression)
- that the bookmark works correctly when jumping back and forth between the worksheets, I think that the expression getfieldselections(year) does not really work in a bookmark.
I have also apply the bookmark as an action when you switch to sheet2.
Do you have any idea how can i solve this problem?