AnsweredAssumed Answered

If then syntax issues

Question asked by kat_hoenke_fws_col on Jun 25, 2018
Latest reply on Jul 2, 2018 by NDierks@BoxElder



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.