I think you have a couple of errors there:
- the calculated field at row 26 cannot perform the operation because the variable ${s1p3} is yet to be computed.
- also, the form supports entering more than one chefe
I would suggest a modification to the flow of your form.
A standard approach would be to collect information about the entire roster, starting from the chefe.
In this case you might want to skip question ${s1p3} for the first person and automatically assign the relation chefe. You could create an additional variable for this.
See example (_odkApp_iadcpc_AM.xlsx (117.3 KB) )
In the attached example I also pulled the name of the chefe from the top of the form, so you don't need to enter it again.
I hope this helps!
Best,
Andrea