Forum Discussion
TechCenter1000
May 12, 2021Copper Contributor
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,...
- May 13, 2021
TechCenter1000 Use this formula in the Days column
=OR(ISBLANK(I2),(TODAY()-I2)<=7)
and filter out FALSE, showing only TRUE.
Riny_van_Eekelen
May 13, 2021Platinum Contributor
TechCenter1000 Use this formula in the Days column
=OR(ISBLANK(I2),(TODAY()-I2)<=7)
and filter out FALSE, showing only TRUE.
TechCenter1000
May 13, 2021Copper Contributor
Thank you!