Is there a formula to have a cell checked when the due date is within 30 days of today?
I am trying to create a report that shows two items 1) Parent rows, 2) tasks under those that are due in 30 days from today. I can get the report to give me the tasks due in 30 days, but I am not getting the parents since the due dates are more than 30 days.
I was thinking I can create a helper column that automatically is checked when the due date is in 30 days and unchecked when not due within 30 days.
Help Article Resources
Check out the Formula Handbook template!