Slicers / Filter to display select criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-2167043%22%20slang%3D%22en-US%22%3ESlicers%20%2F%20Filter%20to%20display%20select%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2167043%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20with%20a%20large%20table%20(small%20excerpt%20below)%20and%20I%20would%20like%20to%20create%20a%20slicer%2Ffilter%2C%20etc.%20to%20display%20only%20projects%20with%20an%20IFC%20submittal%20due%20in%2030%20or%20fewer%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20hope%20is%20that%20my%20boss%20could%20enter%20the%20spreadsheet%2C%20and%20go%20to%20a%20separate%20summary%20tab%20where%20he%20will%20be%20presented%20with%20only%20the%20projects%20with%2030%20or%20fewer%20days%20left%20until%20IFC%20is%20due.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20used%20conditional%20formatting%20to%20call%20them%20out.%20but%2C%20am%20looking%20for%20a%20way%20to%20simply%20present%20the%20Description%20and%20the%20Days%20Until%20IFC%20Due%20specifically%20for%20those%20with%2030%20or%20fewer%20days%20until%20due.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20kind%20of%20lost%20of%20the%20best%20way%20to%20do%20this.%20so%2C%20any%20help%20is%20really%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22871%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22357%22%3EDescription%3C%2FTD%3E%3CTD%20width%3D%22181%22%3EScope%20Summary%20%2F%20Task%3C%2FTD%3E%3CTD%20width%3D%22111%22%3ETeam%20Leader%3C%2FTD%3E%3CTD%20width%3D%2246%22%3EPM%3C%2FTD%3E%3CTD%20width%3D%2288%22%3EDays%20Until%20IFR%20Due%3C%2FTD%3E%3CTD%20width%3D%2288%22%3EDays%20Until%20IFC%20Due%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3EAdam%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E-50%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E--%3C%2FTD%3E%3CTD%3E--%3C%2FTD%3E%3CTD%3ECho%3C%2FTD%3E%3CTD%3ECHO%3C%2FTD%3E%3CTD%3E-43%3C%2FTD%3E%3CTD%3E17%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E---%3C%2FTD%3E%3CTD%3E---%3C%2FTD%3E%3CTD%3EAndy%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E-36%3C%2FTD%3E%3CTD%3E24%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E----%3C%2FTD%3E%3CTD%3E----%3C%2FTD%3E%3CTD%3EAndy%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E-29%3C%2FTD%3E%3CTD%3E31%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E-----%3C%2FTD%3E%3CTD%3E-----%3C%2FTD%3E%3CTD%3EAndy%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E-22%3C%2FTD%3E%3CTD%3E38%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3EAdam%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E-15%3C%2FTD%3E%3CTD%3E45%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E--%3C%2FTD%3E%3CTD%3E--%3C%2FTD%3E%3CTD%3EAndy%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E-8%3C%2FTD%3E%3CTD%3E52%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E---%3C%2FTD%3E%3CTD%3E---%3C%2FTD%3E%3CTD%3EAndy%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E61%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E----%3C%2FTD%3E%3CTD%3E----%3C%2FTD%3E%3CTD%3EAndy%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E68%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E-----%3C%2FTD%3E%3CTD%3E-----%3C%2FTD%3E%3CTD%3EGreg%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3E-%3C%2FTD%3E%3CTD%3EGreg%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E22%3C%2FTD%3E%3CTD%3E82%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E--%3C%2FTD%3E%3CTD%3E--%3C%2FTD%3E%3CTD%3EGreg%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E29%3C%2FTD%3E%3CTD%3E89%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E---%3C%2FTD%3E%3CTD%3E---%3C%2FTD%3E%3CTD%3EAndy%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E36%3C%2FTD%3E%3CTD%3E96%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E----%3C%2FTD%3E%3CTD%3E----%3C%2FTD%3E%3CTD%3EAndy%3C%2FTD%3E%3CTD%3ECDF%3C%2FTD%3E%3CTD%3E43%3C%2FTD%3E%3CTD%3E103%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2167043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am working with a large table (small excerpt below) and I would like to create a slicer/filter, etc. to display only projects with an IFC submittal due in 30 or fewer days.

 

My hope is that my boss could enter the spreadsheet, and go to a separate summary tab where he will be presented with only the projects with 30 or fewer days left until IFC is due.

 

I've used conditional formatting to call them out. but, am looking for a way to simply present the Description and the Days Until IFC Due specifically for those with 30 or fewer days until due.

 

I'm kind of lost of the best way to do this. so, any help is really appreciated.

 

DescriptionScope Summary / TaskTeam LeaderPMDays Until IFR DueDays Until IFC Due
--AdamCDF-5010
----ChoCHO-4317
------AndyCDF-3624
--------AndyCDF-2931
----------AndyCDF-2238
--AdamCDF-1545
----AndyCDF-852
------AndyCDF161
--------AndyCDF868
----------GregCDF1575
--GregCDF2282
----GregCDF2989
------AndyCDF3696
--------AndyCDF43103

 

1 Reply

@ebruzgulis-work 

You may use FILTER() function

image.png

as

=FILTER(Table1,Table1[Days Until IFC Due]<=$K$1)