Automatically check if

ultimatum

If any formula, after filling form check-in or out will be checked automatically if a person is checking in this day?

I need to know if some ppl already check in or out from the another list (sheet).

MichaelTCA

Hello @ultimatum

You can use a lookup function like Index/Match. RANGE1 would be the column that would specify that the person is already checked in or out from the other sheet.

=INDEX(RANGE1,MATCH(Lookup Value, RANGE2, 0)

This function will check the box on this sheet if it's already checked on the other.