IF formula stops referencing columns after a certain point unless I manually type
I have a survey going to to people with 56 compliance rules. When the survey answers as "out of compliance" I have a rules column for each rule change that to a "1". Another column I've made have multiple selection options with the rule number and compliance issue. So Ideally when someone answers "out of compliance for rule 581-022-0106" as well as other coumns, in the single drop down column each rule number and reference will appear as "581-022-0106 State Standards for 2021-22" for example.
The following formula works to achieve this:
=IF([Rule 581-022-0106]@row = "1", "581-022-0106 State Standards for 2021-22") + CHAR(10) + IF([Rule 581-022-2000]@row = "1", "581-022-2000 Diploma Requirements") + CHAR(10)
If someone selects 2000 but not 0106, only 2000 will appear in the summary column. If they select both, both appear. Exactly what I need.
So I made a word doc, wrote out the entire function and it doesn't work! The format is exactly the same, only the column name and output changed. When I paste the function, all the rows stop referencing, and I get an unparceable error. I have to delicately type out function for the refences to stay. Am I doing something wrong? Is there a way to make the rows reference from a plaintext formula?
Help Article Resources
Check out the Formula Handbook template!