topic Re: Survey123 Formula in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/survey123-formula/m-p/861065#M25775 <HTML><HEAD></HEAD><BODY><P>Hi Trisha,</P><P></P><P>Yes, what you are describing should be possible using Survey13 Connect. &nbsp;There is a function, count-selected(), that provides the number of choices that have been selected. &nbsp;Additionally, if you need a question to appear when a specific choice is selected, there is a function, selected(), that will check if a value has been selected. &nbsp;<A class="link-titled" href="http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_CF492D34EF6E49D6ADD4C941686F484F" title="http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_CF492D34EF6E49D6ADD4C941686F484F">Formulas—Survey123 for ArcGIS | ArcGIS</A>&nbsp;provides more information.</P></BODY></HTML> Thu, 12 Apr 2018 19:53:34 GMT JamesTedrick 2018-04-12T19:53:34Z Survey123 Formula https://community.esri.com/t5/arcgis-survey123-questions/survey123-formula/m-p/861064#M25774 <HTML><HEAD></HEAD><BODY><P>Is it possible to use a statement if 1 or 3 items were selected on a multiple list select to allow a user to type a number value in.&nbsp; For example if I have Retail Stores as a label and the choices are: Walmart, Target, Sears, Kohl's, Best Buy and then if the user selects Walmart, Target and Sears a box will show for them to input a dollar amount of an item.&nbsp; Showing that the stores with a dollar amount had a tool they were looking for and the others did not have the tool.</P></BODY></HTML> Thu, 12 Apr 2018 19:44:28 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-formula/m-p/861064#M25774 TKSHEP 2018-04-12T19:44:28Z Re: Survey123 Formula https://community.esri.com/t5/arcgis-survey123-questions/survey123-formula/m-p/861065#M25775 <HTML><HEAD></HEAD><BODY><P>Hi Trisha,</P><P></P><P>Yes, what you are describing should be possible using Survey13 Connect. &nbsp;There is a function, count-selected(), that provides the number of choices that have been selected. &nbsp;Additionally, if you need a question to appear when a specific choice is selected, there is a function, selected(), that will check if a value has been selected. &nbsp;<A class="link-titled" href="http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_CF492D34EF6E49D6ADD4C941686F484F" title="http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_CF492D34EF6E49D6ADD4C941686F484F">Formulas—Survey123 for ArcGIS | ArcGIS</A>&nbsp;provides more information.</P></BODY></HTML> Thu, 12 Apr 2018 19:53:34 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-formula/m-p/861065#M25775 JamesTedrick 2018-04-12T19:53:34Z