Report not filtering out all 100% complete tasks

I have a report to show me all of the tasks that are in progress (not 100% complete) or not started within a timeframe. Therefore, the report is supposed to filter OUT all tasks that at 100% complete.

It has been working for over two years, with two different schedules. But now two items won't fall off of the report (the two at the top). I've included a screenshot of my report criteria and the resulting current report.

I've replaced the '100%' text in the original sheet in case there was an issue with that and the tasks still remain on the report.

What am I doing wrong???

Smartsheet capture 7-3-19.JPG

Find more posts tagged with

Reports

Comments

Mike Wilday

That is really peculiar. I would try changing the source to another sheet and then select the original source again. If that doesn't work. I would contact support. That is really peculiar.

Andrée Starå

Hi Jennifer,

I'm with Mike. It seems like it's stuck and needs a reset. You could also try to make a copy of the report and see if that shows it the same way.

If that doesn't solve it, I'd recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Kevin Hogan

Did you ever get this resolved? I am having the same issue while creating a new report. Smartsheets does not recognize the summary row % complete tasks and displays then even though the filter is written to remove them.

JeremiahHorstick

Is this a rounding issue?

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…