topic Formula in ArcGIS Survey123 Questions

Formula

DrJumaKhudonazarov — Sat, 28 Jan 2023 21:33:29 GMT

Can someone please please advise if the bellow formula is correct?

if(${CF_Rating}='192',high risk}if(${CF_Rating}='130',medium risk}if(${CF_Rating}='120',low risk}

I want to use rating score and if I enter 192 cm in previous question the next note should appear ''HIGH RISK"

Re: Formula

Richard_Purkis — Mon, 30 Jan 2023 12:01:44 GMT

Without your form it is hard to be sure why your formula isn't working. A good recommendation to start is to chain your if statements together.

Each if statement is the 'else' choice for the proceeding if statement until you arrive at the end. That is where you then add the default option if none of your if statements are true. For example:

if(${CF_Rating}='192', 'high risk', if(${CF_Rating}='130', 'medium risk', if(${CF_Rating}='120', 'low risk', '0')))

Hope this helps

Re: Formula

DrJumaKhudonazarov — Mon, 30 Jan 2023 23:02:24 GMT

Dear Richard

Thanks. How I can share my form with you ? Can I send it by email ?

Re: Formula

DrJumaKhudonazarov — Mon, 30 Jan 2023 23:17:09 GMT

I am getting this message

Re: Formula

Richard_Purkis — Tue, 31 Jan 2023 11:29:02 GMT

@DrJumaKhudonazarov

You can attach it to your comment or send it to me in a Direct Message.

Thanks

Re: Formula

DrJumaKhudonazarov — Wed, 08 Feb 2023 17:58:59 GMT

I have sent you a direct message with an attachment please have a look when you have chance