I’ve got a big document. 100s of users, all of our team members in my Organization (200+), and 100s of projects, which all have audit trails attached to track milestones and goals and changes to who is on what and what changes on the project. 10s of thousands of total rows in the doc.
The problem is, things are slowing down. Doing calculations, I learn it’s often some of my audit trail columns. For example, I’ve got a “Goal Date” audit that tracks as we change a launch date. In the main Project row, I want a “Goal Date History” column that shows how we’ve changed the goals for that project. A minor change might cause a pretty big lag due to the audit column including concatenations and multiple full table filters.
I’ve started to resort to making these columns Text (instead of Formula), and doing an automation to update them ~hourly.
I’d like an option built into columns themselves for “Automatically Update” versus “Update every hour/2/4/8/etc” so for the ~50+ columns that really don’t need to be updating constantly for my Portfolio Management tooling, I save all those calculations for the background