I have been working on figuring out this issue forever and could really use some help. Basically, I have a switch formula which pulls in states from another table based on certain criteria. But there are times I need to make an exception for a particular state so I created a column to list states a user might want removed from the list of states. For instance, if there is a list of 30 states which includes AL, but AL cannot be used, I want the user to be able to select AL in the Exception column and it not show in the State column. The problem is the way the state data shows, it groups the states together from the table the formula is referencing, so it’s not as easy as using
!=. I’ve tried
listcombine() for the state and I can get it to show only the exception state with a formula like:
… but I can’t get it to do the opposite.
I’ve made a dummy doc which is paired down to illustrate my issue. I’m working in the State column on the Schedule page/Asset Schedule table.
(The State Override column is for when you have a small number of states which need to override a large number of states. The Exception is for when you need to pull out a small number of states from a large number.)
Any help/suggestions on how to do differently (if that’s what is needed) would be appreciated.
Thank you - Julie