I am trying to create a dashboard for our billing process at a glance. I wanted to display the rows that are checked for updates each month on the dashboard, but I can't figure out how to pull all of it and make sure it updates every month.
I saw someone using =INDEX(COLLECT, but I don't know how that would translate to the dashboard.
Happy to share more details as needed.