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

Adding Days to a Date derived from a formula
Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the number 14 added at the end of the line. Both columns are set to Date Types. The Submission Date is derived from a formula -…
VLOOKUP or IF?
Hello, I am not sure if I should be using VLOOKUP or an IF/THEN statement or a combination of the two. Any help is greatly appreciated. Thank you. Problem Statement: I want the PWS link to auto populate based on the Areas of Support selection. Both columns are dropdowns. Current attempt gives me a circular reference.…
Getting a specified drop down selection based on the range from another cell
I have a sheet that is for prioritization purposes, there are multiple columns that aggregate value into a "Total Score" column, I want my "Priority" column to auto populate a value based on the value in total score ie if value 0-20 it should be P4 if it is 21-40 P3 if 41-60 P2 if 61-80 P1 if 81-100 P0. I used the…