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
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