Filter not working correctly

We have a sheet for project task and have set up shared filters so that each person can filter the task list to show only the task that they are listed as project manager. When the filter is selected, randomly there are task lines shown where other project managers are listed. I can't figure out why this is happening now. This used to work pretty flawlessly.

You can see in below snip that with the filter applied I still have some random lines that are assigned to other PM's.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!