Complex Data transfer based on submission date
I'm working on a reporting & tracking system that was originally set up in MS Access. The current process is very manual for the Ops person, so I'm trying to see if SS's automations & forms will work.
Each team gains points throughout the year based on when things are submitted. As there are 30+ teams, I've created a "Submission" sheet with the forms I want them to complete or upload documents to. What is the best way to track each teams submissions dates (created date auto column) and then assign the points to that team (based on a matrix I'd need to build into a formula)?
Currently, my set up:
- Submission form for all submissions
- Team Tracking Template (one per team)- this is ideally where submission dates are tracked and then points are tallied automatically based on a formula I've created.
- Chapter Portal, where all form links and metrics are on display for chapters to access.
Any ideas on how to best get data to transfer automatically would be great. I've looked into Data Mesh but as I'm working with Dates, it makes it difficult to configure one sheet to multiple different sheets.
Help Article Resources
Check out the Formula Handbook template!