I'm creating seperate reports for each of my users which pulls in all of their tasks. I'd like to remove or hide the tasks that have a '100%' listed in the '% Completed' column. I've added the '% Completed' column to my report and set up the 'What?' to exclude anything in which the '% Completed' cells contain '100%'. Even after running the report, they still appear. Could this have something to do with the formatting of the cell in the sheets having a color and strike-through applied?
Thanks in advance for your help!