Hello,
I have a SharePoint list with a choice column that was originally named Sample3. I changed the column name to Project Status (with a space in between). I'm trying to get the items from that SharePoint list but filter on that choice column to get the items that aren't equal to 'Completed' or 'Cancelled'.
I've tried these three cases in the filter query but keep getting an error that says the query isn't valid:
Project Status ne 'Completed' or 'Cancelled'
Project Status Value ne 'Completed' or 'Cancelled'
Sample3 ne 'Completed' or 'Cancelled'
Am I missing something? Or is there something else I should try? I would appreciate any guidance. Thank you!
