topic Re: Select_Multiple and Field Calculations in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/select-multiple-and-field-calculations/m-p/783890#M6765 <HTML><HEAD></HEAD><BODY><P>Oh look at me go! I answered my own question. I had a field called "Hazard Rating" that I was trying to automatically calculate based on a multiple_select question called "Fail_Potential". In the calculation for Hazard Rating I put this:</P><P></P><P>if(count-selected(${Fail_Potential}) = 1, ‘0’, if(count-selected(${Fail_Potential})&gt;1, ‘1’, ${Fail_Potential}))</P><P></P><P>AND IT WORKS!&nbsp;</P></BODY></HTML> Fri, 30 Nov 2018 21:45:30 GMT deleted-user-jxpbpbjlZInj 2018-11-30T21:45:30Z Select_Multiple and Field Calculations https://community.esri.com/t5/arcgis-survey123-questions/select-multiple-and-field-calculations/m-p/783889#M6764 <HTML><HEAD></HEAD><BODY><P>I have a select_multiple question in my Survey123 where a field worker can select multiple defects on a tree. Then, a later question asks if there are multiple defects on the tree. If yes, then that gets a score of 1. If it's just one defect, that gets a score of 0.<BR /><BR />I want this question to automatically calculate based on the select_multiple for tree defects. How would I calculate this?</P></BODY></HTML> Fri, 30 Nov 2018 21:28:13 GMT https://community.esri.com/t5/arcgis-survey123-questions/select-multiple-and-field-calculations/m-p/783889#M6764 deleted-user-jxpbpbjlZInj 2018-11-30T21:28:13Z Re: Select_Multiple and Field Calculations https://community.esri.com/t5/arcgis-survey123-questions/select-multiple-and-field-calculations/m-p/783890#M6765 <HTML><HEAD></HEAD><BODY><P>Oh look at me go! I answered my own question. I had a field called "Hazard Rating" that I was trying to automatically calculate based on a multiple_select question called "Fail_Potential". In the calculation for Hazard Rating I put this:</P><P></P><P>if(count-selected(${Fail_Potential}) = 1, ‘0’, if(count-selected(${Fail_Potential})&gt;1, ‘1’, ${Fail_Potential}))</P><P></P><P>AND IT WORKS!&nbsp;</P></BODY></HTML> Fri, 30 Nov 2018 21:45:30 GMT https://community.esri.com/t5/arcgis-survey123-questions/select-multiple-and-field-calculations/m-p/783890#M6765 deleted-user-jxpbpbjlZInj 2018-11-30T21:45:30Z