Okay, so this is what we are trying to achieve.
Sales person fills out a google form after every telephone call made. That data then goes into a google sheet as seen below. Then the managers will get emailed a LookerStudio report every morning with the sales people’s call from the previous day.
The issue we are running into is when we try and summarize the data within the “Yesterdays Call Summary” Box
What we would like to see the quantity of calls from the previous day calculated and summarized. In our example above we would have Answered=2, Left Message=1, Bad Number=1. (Assuming you are reading this on May 28, 2024)
We have tried combining COUNTIFS and VLOOKUP but with no success.
Any advice?
Marty Langen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.