I am trying to integrate an Excel dashboard feed through the CommCare dashboard feed link. The dashboard already has multiple sheets and many formulas to process the data entry, which up until now has been entered manually. My goal is to have an automated system where the data will be updated automatically through the dashboard feed link, and for analysis of the data to be automated as well. However, I'm not sure if the analysis can be automated.
Specifically, the dashboard feed link would add a row of data to the Data Entry sheet of my dashboard for each survey filled. The analysis is done in other Excel sheets, and I would need rows in those sheets also to be automatically updated in order for the dashboard to be automatically updated also.
I realize this may be more of an Excel question, but is there a way to ensure that when a new row of data is added to the Data Entry sheet, corresponding rows of analysis (with built-in formulas) are added to the analysis sheets?