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 B3
of sheet2
, I would like write a formula that checks the following :
if the text in B2
of 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 A3
of sheet2
(Robin) exists in column B
among the results that were just matched.
If so - return TRUE
, else return FALSE
.
IF(AND... for making several conditions
FIND to find the text 2019-10-20
in a column with additional characters
=IF(AND(COUNT(FIND(B$2;Sheet1!A:A));A3;Sheet1!B:B);TRUE;FALSE)
This is not working but as far as I get.