Forum Discussion

TechCenter1000's avatar
TechCenter1000
Copper Contributor
May 12, 2021

Job Status Spreadsheet Display - Filtering for ALL or a restricted set of rows

Hello, I'm using Microsoft 365 Excel, working with a simple worksheet for jobs running through a department. It's a simple log containing a Job Number, Customer, Description, Priority, Date Entered,...
  • Riny_van_Eekelen's avatar
    May 13, 2021

    TechCenter1000 Use this formula in the Days column

    =OR(ISBLANK(I2),(TODAY()-I2)<=7)

     and filter out FALSE, showing only TRUE.

Resources