i can't tell you how helpful this is

@SheetsNinja

6 ай бұрын

So glad this was helpful for you!

What should I do if I want to show present and absent? Thank you for your kind help.

@SheetsNinja

8 күн бұрын

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,"

@helenat7468

6 күн бұрын

@@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

@SheetsNinja

6 күн бұрын

@@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?

@SheetsNinja

7 күн бұрын

You can use checkboxes to select multiple items or names in Google Forms.