Filter Helper Question
I am tracking communications for my project, and each row represents a communication (e.g., notify employees of changes to expense policy). I have separate date columns for "Draft Due" and "BU Review Due" and "Legal Review Due" and "Distribution Complete" (see attached). I want to have a filter to show me any rows that have a date in ANY of those columns that is today or in the next 6 days.
I believe I need a column with a formula as a "filter helper", but can't get the formula right.
Can you please help?
Help Article Resources
Check out the Formula Handbook template!