Thanks bro. Will it be simplier for using Google add-on, such as Comfort Attendance, which creates web app to update the attendance sheet by clicking on names extracted from the attendance sheet?
Add-ons can make your life easier if the standard configuration provides what you need. Usually it's the customization to fit your exact needs is where those fall short, or when the cost exceeds the value it provides. If it works for you, then awesome! Otherwise you may look for a compromise of using an add-on and customizing it in the Google Sheet, or building something from scratch like the solution I demo-ed.
You, you could use the "filter" formula instead, so starting in D7, you could use a formula like this: =IFERROR(filter('Form Responses 1'$A:$A, 'Form Responses 1'$A:$A=$C7, 'Form Responses 1'$A:$A>=D$6, 'Form Responses 1'$A:$A
If you want to show "Present" or "Absent" instead of a number, all you have to do is where it currently has a countifs to count if they show up on a day, you can put that into an if statement. E.g.: =IF(countifs('Form Responses 1'!$B:$B,$C7,'Form Responses 1'!$A:$A,">="&D$6,'Form Responses 1'!$A:$A,"
@@SheetsNinja I was trying to freeze up to column C for easier scrolling, but I continue to get error message saying merged cells. Could you please help. Thanks so much
@@helenat7468 This one is a little confusing, but you can't freeze columns or rows if you have any merged cells that merge across where you want to freeze. So for example, on your sheet, you have one or more cells that are merged starting in A, B, or C and going to D or beyond. You'll just have to look through and unmerge any rows that do that so you can freeze where you need to
i can't tell you how helpful this is
So glad this was helpful for you!
Thanks bro. Will it be simplier for using Google add-on, such as Comfort Attendance, which creates web app to update the attendance sheet by clicking on names extracted from the attendance sheet?
Add-ons can make your life easier if the standard configuration provides what you need. Usually it's the customization to fit your exact needs is where those fall short, or when the cost exceeds the value it provides. If it works for you, then awesome! Otherwise you may look for a compromise of using an add-on and customizing it in the Google Sheet, or building something from scratch like the solution I demo-ed.
Thanks a lot..u're solving my problem today..very appreciate!
Glad to hear that
I appreciate you bro. Thank you!
Awesome, so glad I was able to help!
Is there a way to the actual time of the form response, instead of 1 if present, on the weekly attendance sheet?
You, you could use the "filter" formula instead, so starting in D7, you could use a formula like this:
=IFERROR(filter('Form Responses 1'$A:$A, 'Form Responses 1'$A:$A=$C7, 'Form Responses 1'$A:$A>=D$6, 'Form Responses 1'$A:$A
What should I do if I want to show present and absent? Thank you for your kind help.
If you want to show "Present" or "Absent" instead of a number, all you have to do is where it currently has a countifs to count if they show up on a day, you can put that into an if statement. E.g.:
=IF(countifs('Form Responses 1'!$B:$B,$C7,'Form Responses 1'!$A:$A,">="&D$6,'Form Responses 1'!$A:$A,"
@@SheetsNinja I was trying to freeze up to column C for easier scrolling, but I continue to get error message saying merged cells. Could you please help. Thanks so much
@@helenat7468 This one is a little confusing, but you can't freeze columns or rows if you have any merged cells that merge across where you want to freeze. So for example, on your sheet, you have one or more cells that are merged starting in A, B, or C and going to D or beyond. You'll just have to look through and unmerge any rows that do that so you can freeze where you need to
is there a way to select multiple names at once on google forms?
You can use checkboxes to select multiple items or names in Google Forms.