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!