Survey Calculation Formula Returns A Dependency Error.

Question

I’m trying to make a change to an existing survey. Because no default value was set when the survey was created, most records either have a value of “Yes” or “Null.” I’m trying to make a calculation formula that sets a record’s answer to “No” if a null value, but Survey123 keeps telling me I’m creating a dependency cycle (see screenshot). Can anyone tell me where I’m going wrong with the calculation formula below?

if(${survey_status} = '', 'No', '')

Thanks so much!

Dependancy Error.png

Bilal_Alam_GIS_0-1735206117173.png

jcarlson · Accepted Answer

Generally, you can't reference a field in its own calculation. Why not just run a field calculation against the whole table to convert the Nulls to No?