Hello Everyone
I hope you can help 🤞
I have a google sheet being populated by a Qualtrics survey.
I have 1 extra column in my sheet (not being used by Qualtrics), within the cells of this column is a formulae.
For some reason, when a new Qualtrics entry populates the sheet, it skips the row with the formulae in.
Any ideas how to keep the Qualtrics entry and formula on the same row?
Thanks :)
Qualtrics searches for the first empty row, so any row with any column having any data will be skipped. Nothing you can do about it.
If the formula is really important, I would suggest creating another worksheet. Fill all the cells in it to copy the respective element in the Qualtrics sheet (something like =Sheet1!A1) and the have a column with your formula there.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
