Hi
I have a sheet "Tasks" with data in with the following column headings:
ID
Subject
Details
"Date Created"
"Due Date"
"Came from"
Priority
Status
"Allocated to"
I want to list this information in another sheet "Dashboard" if the due date is older than a certain date so that it only shows the overdue tasks, but I do not want any blank rows.
I have a sheet "helper sheet" with all my lists for data validation and for formulas to be listed.
So for example IF "Due Date" < 'Helper sheet'!C2 then display in that rows details (A:I) on "dashboard"
Any help is appreciated, thanks
Nic
Bookmarks