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?

Options

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
Options
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

How do I pull in a value using 2 criteria?
I want to use Project Name and Resource name as a criteria to pull hours worked into a different sheet. Please help.
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
Whats the formula to find todays date between a range of dates to provide a value?
i need a formula to find todays date between the start date and end date, then provide the current sprint