Hi,
I am trying to get this calculation to work in survey123 xls, and I think my syntax is incorrect. Can someone help?
if(${CrossingSpanId},'Spans Full Channel & Banks',1,if(${CrossingSpanId},'Spans Only Bankfull/Active Channel',0.9,if(${CrossingSpanId},'moderate',0.5,if(${CrossingSpanId},'severe',0,if(${CrossingSpanId},'Unknown',1,'NULL')))))
Error: Xpath Evaluation cannot handle funciton 'if' requires 3 arguments, only 4 povided.
TIA!