Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Reporting - % Complete filter not working?

ACharvet

ACharvet ✭

07/02/15 edited 12/09/19 in Archived 2015 Posts

Tried to filter for tasks that are LESS Than 100% complete, however 100% tasks are displaying.

Tags:

Reports

0 ·

Comments

Richard Rymill SBP ✭✭✭✭✭✭

07/06/15

Hi
Easy mistake to make, change your amount to just 1 not 100 then you will get what you want. Ie 1 = 100%.

Richard Rymill

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Is it Possible to Have a Form Pull From a Summary Field on the Sheet?
I believe I've seen that this isn't possible but wanted to check if anything has changed or if someone came up with a solution. I have a form where people sign up for a tour. In the main sheet I use the Sheet Summary to keep track of how many spots are left for the tour. I would like to pull from this Sheet Summary field…
Missing Reports on a Dashboard. Then suddenly appears after refreshing. Then missing again.
Hi everyone, Have you experienced being haunted by a Report widget within the dashboard? Our Clients were complaining that some tables within the dashboard suddenly went missing, but after refreshing, it will appear and then gone again. This is my first time encountering this, and I've already raised a ticket to Tech…
Dashboard Issues & Privacy
I have a master data sheet with data on it for 5 different clients. I've then created a series of reports that filter information for each client so they can view their own data without seeing everyone else's data. But I can't give them access to a report without giving them access to the source sheet. So I created a…