Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to make a default selection for a sheet i am developing. I am trying to filter a certain field called 'Panel_ID.' the filter is like such: IF(NOT(PANEL_ID >= 89000 and PANEL_ID <= 99999) but for some reason the selected panels after that script is inputed into a filter pane are not following the logic. Am i writing that wrong or is there a syntax im not using properly? I am also trying to make this a default filter that a user cannot disable no matter what. throughout the app there are multiple buttons and filters that users can select to filter for specific panels. However, I want to exclude the range of panels listed above indefinitely without changing the load script.
does no one have a answer to this??