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?
>Solution :
You may try this in Cell_L8 for Answered:
=arrayformula(countifs(E:E,K8,int(A:A),today()-1))