using a filter selection in dashboard to filter out account
Hi I have created a dashboard where i want the user to be able to filter out month and the account.
I have created a sheet that is taking the data out of 14 sheets and populates the first row based on the selection made in the dashboard. i have done that using a form that has 2 fields (account and month).
The data is then used in a countifs to find the data in the sheets, so far so good.
I have set the form to add the submitted data at the top. All formula fields are set as column formula.
every time you submit the form a new line is added to the sheet and as such also the data is shown in the dashboard. I don't want that, I only want the new selection to be visible. So I want the old row to be remove when the new row is entered in the sheet.
I tried to do this with a workflow but it is very unstable. Is there an easy way to remove the "old" row when new data is submitted?
could data schuttle help here?
Help Article Resources
Check out the Formula Handbook template!