Odd behaviour with new form entries on sheets

Options
CRL Planning
CRL Planning ✭✭✭
edited 04/26/22 in Formulas and Functions

We have multiple sheets that are populated at the top of the sheet by forms.

These sheets have worked for over 5 years now but all of a sudden the data being entered at the top of the sheet is not picking up the formulae that are in the top row. The formulae that are being picked up are acting on the previous top row and giving incorrect results.

Has anyone else noticed strange errors in sheets being populated from forms and if you have, have you managed to find a fix.

Murray (CRL Planning)

Answers

  • Ross C
    Ross C ✭✭✭
    Options

    We are seeing the same issues over the last several weeks. There are a couple of different discussions regarding this same issue.

  • CRL Planning
    Options

    OK Ross, thanks for pointing me to this.

    I have raised a ticket on the matter and at the moment I have been advised to change my formulae to @row formulae but this is not so easy when you want them to act on specific data columns.

    Murray

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!