I have looked all over and not quite found the answer to my question. I have tried a lot of INDEX and MATCH posts which offer COUNTIF or an absolute, like 3 which is not what I’m after.
I have a sheet with some workflow information on Sheet1 and I’m trying to create a summary dashboard that copies over only relevant data onto Sheet2.
Table below shows original sheet
|Team||Requested date||Not needed||Not needed||Status||Completed date||Request||Summary|
|DEF||7-May||x||y||In progress||Monkey||Needs bananas|
|DEF||1-May||x||y||in progress||Giraffe||Would like someone to check his neck|
What I would like my dashboard to show is the request name, the summary, the team and the completed date. BUT only where status = completed AND within a specified date range
Thanks in advance.