Hi Guys,
Really need help asap - work project.
https://docs.google.com/spreadsheets/d/1_sv65EOBbgGqfcMtF7L6rSEl_Iba7NAX56mK6O1Ns2o/edit?usp=sharing
On the Data for Dashboard tab I want it to =Query data from the main data, depending on what option are picked in the dashboard sheet (REP NAME AND THE DATE RANGE)
I have a created a formula which you will see on the "Data for dashboard" sheet, but it is not working.
Please can genius help me this.
Really need help asap - work project.
https://docs.google.com/spreadsheets/d/1_sv65EOBbgGqfcMtF7L6rSEl_Iba7NAX56mK6O1Ns2o/edit?usp=sharing
On the Data for Dashboard tab I want it to =Query data from the main data, depending on what option are picked in the dashboard sheet (REP NAME AND THE DATE RANGE)
I have a created a formula which you will see on the "Data for dashboard" sheet, but it is not working.
Please can genius help me this.