IF statement for a check box helper column
I have a form that has a status of sick or returning. There are other columns but not needed for the formula (other than name).
I want to add a helper checkbox and when someone submits a form for returning (they will have already submitted one for sick) the matching "sick" row and the new returning row will match the name and both will have the helper checkbox checked.
The point of this will trigger an automation to move any checked boxes in the helper column to an archive sheet.
Help Article Resources
Check out the Formula Handbook template!