This is a weird one, and it's been happening for some time.
I have a sheet that people add to, in a batch copy and paste style. There are a few columns to the right of the batch data that process the cells and gleam certain information. It's nothing resource-intensive: e.g. in one cell we might have a person's team and sub-team, so the formulas in the columns simply extract the team in one column, and the sub-team in another. A couple of other columns then Index Match against another sheet to pull data, and finally there are a couple of Formula Helper columns that either fire up a checkbox or not, depending on the criteria (again though, not a complex formula).
Now, when someone puts a batch of data into the sheet, Smartsheet does what it does and the formula copies down automatically. However, no results actually show for a while. Sometimes it can take days! It's like it sometimes waits for another person to go in and start playing around before it fires into action.
So the formulas themselves are not intensive. I've streamlined them as much as I can using @row and @cell where necessary. I've tried copying and pasting the values only where possible to minimise the number of formulas. I've tried using the new Column Formula function. And there are only just over 5000 rows which isn't a lot of data! 19 columns, including the formula columns. It can't be at the limit of the sheet or it wouldn't work at all, but it just takes ages to process and it needs to happen immediately or there's absolutely no point using Smartsheet for this purpose.
What am I doing wrong? Other sheets are using the information that is processed in the formula columns, but I don't think that impacts on the performance.
Any ideas? It's driving me mad.
