Attendance Sheet in Google Sheets Using forms

Asked Jul 22 '22 at 04:58

Active Jul 22 '22 at 13:04

Viewed 126 times

This is a pseudo code for my excel work

IF sheet1(column(range)).value IS Exit in sheet2(column(range)).value on specific(date) in sheet2(column(range)).value(date) Then print "P" Else print "A"

Hello guys i create a google form for employee attendance so i want that when employee submit their form and automatic update in daily attendance sheet in google sheet. but i don't find any solution regarding this issue and i need to create like in images Daily Attendance Sheet

edited Jul 22 '22 at 13:04

asked Jul 22 '22 at 04:58

HackyCoder0951

please share a minimal reproducible example, it will be easier to help you in your locale – Mike Steelson Jul 22 '22 at 05:44
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. – Community Jul 22 '22 at 06:33

Attendance Sheet in Google Sheets Using forms

0 Answers0