Error on copying a formula from one row to the next row
I am using the Survey Intake - Employee Pulse Check template package to create an NPS survey sheet, report and dashboard. I've updated my questions on the template sheet and I am now editing the "helper columns" to reflect the changed questions. I created a formula to count my responses on the first row, but when I try to copy the same formula on the other rows I get an error "#INVALID OPERATION" I even tried to use the "Convert to Column Formula" but I get the same error message. Has anybody experienced something like this? How can I troubleshoot this error? - Thank you!
Help Article Resources
Check out the Formula Handbook template!