test_calcul.xlsx (15.7 KB)
I created a form that ask the responder to enter the number of organizations that participated in an event. Once the responder enters the names of these organizations, they appear in the matrix so we can proceed to enter the number of participants for each catgory of persons.
@Kal_Lam i just realised my form wasn’t valid since my calculations use the if function with an inaproppriate logic. Is there a workaround to make sure the integers related to an organisation reset to 0 whenever i removed this organisation ?
I found a way to work it around, which was to recalculate every element of the matrix using a if function in a calculation to make sure that when the respondent remove an organization, the values reset to 0.