Forum Discussion
Calculated Columns and Filters
Hi Amapola67
if you found the solution, perfect. But as it concerns to lists views, you can have a large number of filters applied.
You can set them on the "modern view" or you can go to the list settings > edit the view > filters option.
Regards
Hi Amapola67
is there any reason you can't create/modify the view and apply filter conditions in the view itself to apply your filter rules instead of depending on a calculated field?
See Create or modify a filtered view based on column indexes chapter in this article https://support.microsoft.com/en-us/office/use-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4#OfficeVersion=Online
Regards,
I need 3 filters and a view is limited to 2. Which means I need a helper column.
I've worked it out, the formula was incorrect. The -1 is not required.
=IF(AND(OR(Status="Active",Status="Future"),Company="SHS")=1,"True","FALSE")
This works:
=IF(AND(OR(Status="Active",Status="Future"),Company="SHS"),"True","FALSE")
Hi Amapola67
if you found the solution, perfect. But as it concerns to lists views, you can have a large number of filters applied.
You can set them on the "modern view" or you can go to the list settings > edit the view > filters option.
Regards
