Hi! I’m trying to create a dataset that will track changes-over-time for scoring attributed to different individual entities, and having a second table/chart lookup the most recent values for all of the entities. I had been doing this in Google Docs by way of a custom formula that would allow me to use a different table for each entity and pull out the table name to use as a field as well as the last row that was entered.
In Grist I’m trying to organize the data in a more logical way, by where it comes / who enters it instead of just a ‘weekly’ summary entered for each entity.
Am I going about this the right/wrong way? Was having a table for each entity with rows entered chronologically easier to work with in Grist rather than having tables organized by “data source” with entries entered whenever?