Transfer of employees’ reports to one Google table
There are a few employees who carry out the work in their tables. I need to transfer these data into a single, general table. It is necessary to filter these data according to certain parameters.
There are 5 employees, each working in such a table (https://docs.google.com/spreadsheets/d/.............=sharing)
The task:
- to display how many accounts the employee launched on a given day, according to the number of dates in the "start date" column
- to display the number of baths for that day, break into 5 types of baths according to the staff's table
- to reflect the parameter "in which stage it has banned" according to the 4 types
- to display the total number of deleted accounts (the deleted account with the "Deleted" parameter more than 1000).
- to display the outlet accounts according to the type of outlet from the employee's table
- to display the total number of accounts with the "frise" parameter, dispersing them according to the type of frise.
There are 5 employees, each working in such a table (https://docs.google.com/spreadsheets/d/.............=sharing)
The task:
- to display how many accounts the employee launched on a given day, according to the number of dates in the "start date" column
- to display the number of baths for that day, break into 5 types of baths according to the staff's table
- to reflect the parameter "in which stage it has banned" according to the 4 types
- to display the total number of deleted accounts (the deleted account with the "Deleted" parameter more than 1000).
- to display the outlet accounts according to the type of outlet from the employee's table
- to display the total number of accounts with the "frise" parameter, dispersing them according to the type of frise.