Odd behaviour with new form entries on sheets

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
-
We are seeing the same issues over the last several weeks. There are a couple of different discussions regarding this same issue.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!