Latest Contributions by Katie_Clark

Hello! Assuming I understand your question correctly, this is very simple to do, you'll just need to use IF statements in the calculate column.  Below is the sample syntax from the Survey123 documentation: if(selected(${question_one}, 'yes') and selected(${question_two}, 'yes'), 'yes', 'no') I don't know the exact field names you're using, but I think you'll just need something like this. This would be put in the calculate column for a field called "Stream_Type" or something along those lines: if(${stream_score} >= 30, 'Perennial', if(${stream_score} >= 19, 'Intermittent', 'N/A')) So, that syntax might not be exactly correct (it's often a little bit of trial and error to get it just right) but that just says if the stream score is greater than or equal to 30, assign the value "Perennial" to the field. If that's not true, check if stream score is greater than or equal to 19, and if so, assign the value "Intermittent". If neither of those are true, assign "N/A". I hope that helps get you in the right direction!!   P.S.  I asked a question myself about nested if-statements a couple years back and I still reference it to this day for syntax help! haha ... View more