Complicated equations in calculate for xls forms survey123?

Discussion created by kat_hoenke_fws_col on May 3, 2018
Latest reply on May 9, 2018 by tim.tapp_BigRivers



we we are currently using survey123 for collecting field data on aquatic organism passage barriers in the field. Our survey is set up with a repeat that equates to a table relate for each pipe at a road stream crossing.


once data is collected, we must export the data and bring it into excel to do some logistical excel if/then calculations and then some equations to get a final barrier score which we then must re upload. 


my question is, does anyone know the exact limitations for how complicated I can get in the calculate field for xls forms? I can’t seem to find anything more complicated that someone has done other than adding a tip to a bill. Can I use if/then in xls forms? 


If this is possible it would be a huge breakthrough for us!