Smartsheet Error even though sheet is functioning at speed with no other issues

L_123

Myself, and many of my users are encountering this message on a sheet that I have. It doesn't effect performance, and I have zero connectivity/access issues, but I get this every time I save. Is anyone else having this issue? It only seems to occur on the most complicated of my sheets.

@Genevieve P

@Paul Newcome

Genevieve P.

Hi @L@123

I'm glad to see that this has hopefully been resolved, but if it happens again I would suggest reaching out to Smartsheet Support and provide them with the sheet name / URL so that they can check into any back-end issues for you.

Mike Wilday

We're not seeing that error right now. :(

L_123

@Mike Wilday Thanks for the response mike. It's really weird to me. The formulas are complicated, there's other sheet references, there's multiple std dev formulas across several ranges and even z table lookups, all on dynamic ranges on reference submission pages that are submitted every hour, and archived automatically every 30 days. Even with all that it still calculates pretty much instantly, but still pops the error, not on calculation, or when anything else changes, but on save.

I mean, it isn't the end of the world as all I have to do is click off of the alert and keep doing what I want, but it is still stopping some users from progressing as they think they didn't do something correctly.

Mike Wilday

That is strange behavior. I would definitely report it to Support if you haven't already.

Paul Newcome

I haven't had any issues lately. I do remember that when I exceeded the cell character limit, the entire sheet would work fine until I tried to save. Then I got an error. I don't remember the exact error, but it sounds like your sheet is functioning the same way.

L_123

I didn't think it's the character limit.... but now that you say that one of my formula's on the sheet does come to mind. I wonder if it is this that's causing it.

=IF(ISBLANK([OP 10 Measurement]@row), "", IF([Std Devs Tol from Mean]@row >= 5, 0, 1000000 * (1 - INDEX({Z Table All}, MATCH(INDEX(COLLECT({Z Table A}, {Z Table A}, FIND(ROUNDDOWN([Std Devs Tol from Mean]3, 1), @cell) > 0), 1), {Z Table A}, 0), MATCH(INDEX(COLLECT({Z Table R1}, {Z Table R1}, FIND(ROUNDDOWN([Std Devs Tol from Mean]3 - ROUNDDOWN([Std Devs Tol from Mean]3, 2), 2), @cell) > 0), 1), {Z Table R1}, 0))) + IF(OR(CONTAINS("R/O", [OP 10 Measurement]@row), [Std Devs Tol from Mean]4 >= 5), 0, 1000000 * (1 - INDEX({Z Table All}, MATCH(INDEX(COLLECT({Z Table A}, {Z Table A}, FIND(ROUNDDOWN([Std Devs Tol from Mean]4, 1), @cell) > 0), 1), {Z Table A}, 0), MATCH(INDEX(COLLECT({Z Table R1}, {Z Table R1}, FIND(ROUNDDOWN([Std Devs Tol from Mean]4 - ROUNDDOWN([Std Devs Tol from Mean]4, 2), 2), @cell) > 0), 1), {Z Table R1}, 0))))))

Paul Newcome

While that is a rather impressive formula, I don't see how it could be the issue. Have you tried recreating the sheet and removing all other formulas aside from this one to see how it would react? Or possibly just recreating the sheet entirely?

L_123

Yeah... I have this same sheet 3 times for different products, and the issue applies to all of them, so I've rebuilt it twice doing what you said.

The reason i thought of that formula isn't just because it is long, but it has quite a few other sheet references. Maybe it is causing latency during the update, and the program isn't thinking it's caught up when I save...

Paul Newcome

Hmm... And have you removed all except for that formula from one of the sheets to see if that will pinpoint it to that particular formula? I assume you have reached out to support already? I'd be curious as to what they would have to say.

L_123

I deleted and remade a formula that references the formula from above, and the error isn't popping anymore. Not a single character different..... I'm going to leave this open for a bit and see if it comes back.

@Paul Newcome I was trying to avoid that... narrowing it down by formula would be particularly difficult on these sheets.

Paul Newcome

I was just thinking that particular formula since you had a feeling it was that one specifically.

But it sounds like maybe it was the second one referencing the formula you posted. Fingers crossed it keeps working.

Genevieve P.

Hi @L@123

I'm glad to see that this has hopefully been resolved, but if it happens again I would suggest reaching out to Smartsheet Support and provide them with the sheet name / URL so that they can check into any back-end issues for you.