My Tasks report please help me troubleshoot!
I have set up a My Tasks report for leaders, and it's not working, which is not good. They don't have access to the underlying sheet - is that why? (in which case what's the point?)
It's linked to the right sheet, and is filtered for a contact column where when filtered for "has any of" you see everyone's emails listed out, and only "current user" is selected.
The report is in a workspace I share with one other person, and is the only item in that workspace that's shared to everyone, so they have it in their sheets (or more realistically they go back to the email with the link each time.
They are shared to it as Editor-can share
Does anyone have any idea why it's genuinely coming up blank to them when they're signed in with the email from the contact column, and the underlying sheet definitely has them in the contact column for a bunch of rows?