Forum Discussion
Forms + Excel + Rolling 12 + Live updates
After our company reorganization, we are having to build tools we had before that we no longer have access to. Once a month, all departments are required to submit data about their performance. This...
We then need that data to populate a KPI type tab where we select the location and time period to display without having to copy data from the Form data collection spreadsheet to paste in the sheet where the calculations are performed
As far as I know, Ms Forms do not provide custom report function.
Of course,you can use Power Automate or build your own online Form with PHP etc. to achieve your task automately.