
Announcements
We have multiple locations. At the end of each day, each location will fill out a form answering how many people were seen, how many people were new, and how many people were released. This data is going to go in to a spread sheet so we can see everyone's responses in one place. I have the spreadsheet with all the dates listed for the rest of the year. Ideally, when the form is answered, power automate will find the column matching the date entered on the form, and update the corresponding metric.
I am getting completely stumped on how to do this.