Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Very Large Save Causes Formula Corruption
I've been trying to understand a problem I'm having with two of my largest Smartsheets. If I move a row up or down or insert or delete a row, especially near the top of the sheet, the Save process will apparently corrupt formulas here and there in my sheet with no warning or error message given. I've gone back and forth with Smartsheet support several times and they say this is caused by having a large number of rows and columns, the number and complexity of formulas, amount of conditional formatting and the latency from my computer to the Smartsheet servers. No specifics can be given as to sheet size or number of formulas is available to let you know you are getting close to having a problem so I'm going to have to break my sheets up into two or more smaller sheets to solve the problem which will be inconvenient.
The sheet I have the most problems with is quite large with 1600 rows, 31 columns, three conditional formatting rules and about 20,000 formulas ranging from very simple to complex nested IF statements. It also has about 1600 incoming links. It takes a couple of seconds to save if no rows have been moved but 30 - 120 seconds if rows are moved, especially near the top of the sheet.
Does anyone know of any guidelines on sheet size or number of formulas that would be "safe"? I fixed all the formulas yesterday and then inserted about 12 new rows about 20% from the bottom of the sheet for readability, saving after every three or four row inserts, and that corrupted about 250 total formulas in about 30 rows at random places in the sheet.