Trouble filtering 'old' rows based on an AND condition
I have a sheet with a Modified (Date) column and another column with a status indicator in the form of a dropdown menu. I am trying to make a filter that shows all rows where the Modified (Date)
date is 100 days in the past AND a specific option (stand-by) in the dropdown menu has been selected.
I have tried using:
What am I missing? 🙄
Help Article Resources
Check out the Formula Handbook template!