Mark Checkbox if Emails in both sheets are equal and response to Opt In is Yes

Cristina R.R.

Needing to know if this is a possibility to link a sheet that is generated from Form responses to mark a checkbox in the destination sheet automatically. This is to be applied to the whole column. This way as form responses come in, it would ideally update the destination sheet. IF the Email on the Source Sheet is equal to the Email on the Destination Sheet AND the Opt In is equal to Yes on the Source Sheet, THEN mark the Opt In checkbox on the Destination Sheet.
If this is not possible due to the way the Opt In column is formatted on the destination sheet (checkbox), I am open to recommendations to obtain a solution.

Melissa Yamada

Hello @Cristina R.R.

try this formula on your Opt In column on your destination sheet:

=IF(AND(HAS({Email Column on Source Sheet},Email@row),INDEX(COLLECT({Opt In Column in Source Sheet},{Email Column on Source Sheet},Email@row),1)="Yes"),1,0)

Change references accordingly.

Michelle Choate 2

Super Easy! The { } are references from the form sheet. This would be your formula in the destination sheet Opt In checkbox column.

=IF(AND({Email} = Email@row, {Opt In} = "Yes"),1,0)