Issue with Index Collect Formula
Looking for help! We collect form responses that load onto this sheet below the KPI section. I need to see, at a glance, TODAY'S responses in the Reporting Data section. So I'm using an INDEX COLLECT formula to pull in today's response from each team member. However, I am getting the errors as shown below. I simply want to display the data submitted for each person.
Can someone help please? Thank you!