This content has been marked as final. Show 3 replies
I am trying to create a textbox that reflects a single string value depending on the current selections and a formula integrated in the textbox itself.
Textbox currently contains the following query: =if([Event Year]=2017), 'Resort')
My Database is organized this way:
|2017||World Cup||A-City||Game 2|
|2016||World Cup||B-City||Game 1|
|2016||World Cup||C-City||Game 2|
|2017||European Cup||D-City||Game 1|
|2016||European Cup||E-City||Game 1|
Now, as soon as the user filters to event "World Cup", the textbox should be able, with the help of the if-formula, to reflect the respective single value, as for 2017 there is only one distinct value in this column?
However in order that the formula correctly shows "A-City", I have to filter to Event year 2017 with the help of a listbox.
Does anybody see the mistake I am making, or the information I am missing?
Thanks a lot