Hello all,
first, thanks for helping!
So, I have 2 choices columns in my sharepoint list.
When I use 1 column to test, it works perfectly. but when I user the other, it is not filtering!
I checked everything, I debug, filtered data in SP to compare.
The only difference between this columns, is that one has the "REQUIRED" check and the other (which is not working) does not have.
Is that a problem?
Here is the formula:
the ccb_50 (combobox)
when I pick up a value in this combobox, it is not filtering!
All other columns works perfectly, I tested.
But for some reason, this columns is not working. And the difference of this column to other is that this column does not have the "REQUIRED" in sharepoint list. But they are exactly the same.
So, where is the not working part? I see only 1 red underline in the picture
So, if I change this Status, the formulas turns to error. It wont allow me to do this change. But, even though there is a delegation warning, this filter is working perfectly by filtering only active!
Try Status.Value = "Active" instead of Status = "Active"
---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!