Random discontinuation of formulas in sheets

Marcin P
Marcin P
edited 12/09/19 in Formulas and Functions

HI all!

I have a several sheets with formulas. Normal, as almost every user of Smartsheet. I wonder if anyone else has the same issues with formulas as me.

Sometimes, for long time my formulas are copied automatically from row to row without any problems, but randomly, without any reason system stops doing this and I have no idea why. It does not matter if sheet is fed by forms or by direct work in sheet.

The problem is that if I have any notifications triggered by result of formulas, then it doesn't work at all, so I have to keep an eye on it by creating workaround like another formula that checks if the number of rows is equal to the number of triggers (formulas in all rows) and if not, I have a notification rule to be sent to bring my attention and copy formulas by hand, which is nonsense if the number of sheets will grow.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!