topic Best way to remove error message when filling out type in XLSform? in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/best-way-to-remove-error-message-when-filling-out/m-p/802151#M11080 <HTML><HEAD></HEAD><BODY><P>I'm using Excel for Mac v.16.18 and filling out Survey123 advanced template to create a form. I have select_multiple questions in my form and&nbsp;each time I go to add&nbsp;a select_multiple siteHabitat or select_one in the first column of the worksheet, I get an error "Not a valid XLSForm type". The select_multiple has all of its options written out in the choices spreadsheet and works flawlessly when I test the form.</P><P></P><P>What is the best way to hide that error message and speed up my workflow?</P></BODY></HTML> Mon, 28 Jan 2019 22:49:38 GMT ColinDurkin 2019-01-28T22:49:38Z Best way to remove error message when filling out type in XLSform? https://community.esri.com/t5/arcgis-survey123-questions/best-way-to-remove-error-message-when-filling-out/m-p/802151#M11080 <HTML><HEAD></HEAD><BODY><P>I'm using Excel for Mac v.16.18 and filling out Survey123 advanced template to create a form. I have select_multiple questions in my form and&nbsp;each time I go to add&nbsp;a select_multiple siteHabitat or select_one in the first column of the worksheet, I get an error "Not a valid XLSForm type". The select_multiple has all of its options written out in the choices spreadsheet and works flawlessly when I test the form.</P><P></P><P>What is the best way to hide that error message and speed up my workflow?</P></BODY></HTML> Mon, 28 Jan 2019 22:49:38 GMT https://community.esri.com/t5/arcgis-survey123-questions/best-way-to-remove-error-message-when-filling-out/m-p/802151#M11080 ColinDurkin 2019-01-28T22:49:38Z Re: Best way to remove error message when filling out type in XLSform? https://community.esri.com/t5/arcgis-survey123-questions/best-way-to-remove-error-message-when-filling-out/m-p/802152#M11081 <HTML><HEAD></HEAD><BODY><P>That happens to me when I copy and paste between xls sheets and the reference to validate the data gets missing. If you trust yourself you can just remove the validation settings for that column but then the field also does not give you the choice any more. You can remove the validation settings on the Data tab -&gt; Data Validation -&gt; Data Validation... &nbsp; -&gt; clear all. Does that solve the problem?</P></BODY></HTML> Tue, 29 Jan 2019 12:39:08 GMT https://community.esri.com/t5/arcgis-survey123-questions/best-way-to-remove-error-message-when-filling-out/m-p/802152#M11081 Nicole_Ueberschär 2019-01-29T12:39:08Z