Complicated equations in calculate for xls forms survey123?

Discussion created by kat_hoenke_fws_col on May 3, 2018
Latest reply on Jul 9, 2020 by dougbrowning



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!