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)
Help Article Resources
Check out the Formula Handbook template!