We recently upgraded to the team plan for the hourly refresh capabilities, particularly with the Slack pack. We’re finding the refresh takes some time, however, and when it’s running, doc users actions like button clicks spin and spin and spin. Support confirmed this is a known issue, that formula are executed synchronously and sequentially.
It surprises me these refreshes are not asynchronous, but regardless, this is a problem for us, so I hope and assume it has been bumped into and worked around for others. Do you have strategies in place? If so, I would love to hear them.
My immediate thought was to, at a minimum, refresh only the rows that need refreshing, as opposed to the entire pack column. However, it doesn’t seem like the refreshColumn function can be filtered to a subset of rows.