I am trying to make a class attendance system where the student checks in by submitting her name into google forms. The final result will be displayed in Google sheets by marking a check box after each of the present student´s name.
So, In Google Sheets,in cell
sheet2, I would like write a formula that checks the following :
if the text in
sheet2 (2019-10-20) matches
column A of
sheet1 where the text contains additional characters (2019-10-20 04:15:25)
AND if the text in
sheet2 (Robin) exists in
column B among the results that were just matched.
If so - return
TRUE, else return
IF(AND... for making several conditions
FIND to find the text
2019-10-20 in a column with additional characters
This is not working but as far as I get.