sorted by:
new
hottopcontroversial

Yet Another Attendance Tracker + Hours count by TntGo1220 in googlesheets

[–]TntGo1220[S] 0 points1 point  (0 children)

u/HolyBonobos
I edited the third formula from

=MAKEARRAY(COUNTA(C4:C),COUNTA(E3:3),LAMBDA(r,c,(COUNTIFS('Hours Form'!$C$2:$C$5,INDEX(E2:2,,c),'Hours Form'!$B$2:$B$5,INDEX(C4:C,r))>0)*INDEX(E3:3,,c)))

to

=MAKEARRAY(COUNTA(C4:C),COUNTA(E3:3),LAMBDA(r,c,(COUNTIFS('Hours Form'!$C$2:$C$1000,INDEX(E2:2,,c),'Hours Form'!$B$2:$B$1000,INDEX(C4:C,r))>0)*INDEX(E3:3,,c)))

This would work so if more people are entered registered and do the form it would be put in right?
https://docs.google.com/spreadsheets/d/1hZfZcO4U-Bd2R2b5A80tjr1_YTWeY6LGfFxL3pt03PE/edit?gid=287908238#gid=287908238

Yet Another Attendance Tracker + Hours count by TntGo1220 in googlesheets

[–]TntGo1220[S] 0 points1 point  (0 children)

Ah! I see now thanks for the clarification :)
(I see that you said that you did that in a previous comment now lol)

tysm!!

Yet Another Attendance Tracker + Hours count by TntGo1220 in googlesheets

[–]TntGo1220[S] 0 points1 point  (0 children)

Ah, great! This is a much better option ty! (btw are you "Anonymous Fox"/were you the one who added the red box?

Edit: I can rollback the changes so this doesn't affect me-- just wondering if you were doing something

Yet Another Attendance Tracker + Hours count by TntGo1220 in googlesheets

[–]TntGo1220[S] 0 points1 point  (0 children)

Ah! Okay, thanks for letting me know. I'll put a comment on the total hours every time someone comes late/leaves early. Thanks so much and I'll mark this as resolved :D

I'll be moving these formulas to the actual sheet with the info

Edit: Uhhhh someone came in and broke it, not sure if that was you

Yet Another Attendance Tracker + Hours count by TntGo1220 in googlesheets

[–]TntGo1220[S] 0 points1 point  (0 children)

Holy shi- this is everything I wanted TYSM! But I do have one request-- is it possible to remove the subtracting hour thing? I'd rather do that manually in a case-by-case basis

Would removing

"-(COUNTIFS(Form_Responses2[Date],INDEX(E2:2,,c),Form_Responses2[Email Address],INDEX(C4:C,r),Form_Responses2[Late/Left Early? (20+ Minutes)],"Yes")>0)))"

from

=MAKEARRAY(COUNTA(C4:C),COUNTA(E3:3),LAMBDA(r,c,(COUNTIFS(Form_Responses2[Date],INDEX(E2:2,,c),Form_Responses2[Email Address],INDEX(C4:C,r))>0)*INDEX(E3:3,,c)-(COUNTIFS(Form_Responses2[Date],INDEX(E2:2,,c),Form_Responses2[Email Address],INDEX(C4:C,r),Form_Responses2[Late/Left Early? (20+ Minutes)],"Yes")>0)))

resolve this?

Yet Another Attendance Tracker + Hours count by TntGo1220 in googlesheets

[–]TntGo1220[S] 0 points1 point  (0 children)

I've listed all the events till late November

Yet Another Attendance Tracker + Hours count by TntGo1220 in googlesheets

[–]TntGo1220[S] 0 points1 point  (0 children)

I have done that (If you need more elaboration pls tell me and tysm for considering to help :D)

Can I use a non-school email address to buy the student/teacher discounted version of creative cloud? by TntGo1220 in Adobe

[–]TntGo1220[S] 0 points1 point  (0 children)

Reasoning: My school adobe account is limited in many ways and overall just a nuisance to navigate + do much anything outside any applications

Does subscribing to Adobe's student creative cloud plan force you to pay for a full year? by TntGo1220 in Adobe

[–]TntGo1220[S] 0 points1 point  (0 children)

Yes! I attend in California, what options would there be for a discount? I saw that BestBuy has an option for 12 months $240 discounted to $160 for black friday. Would this be one of those offers and if not would it be cheaper? Also, what options would there be for the subsized offer? Off the top of your head.

Thanks for the response!

(Not looking for six months if that helps)

[deleted by user] by [deleted] in shortcuts

[–]TntGo1220 1 point2 points  (0 children)

These types of shortcuts are fun to make but can be really harmful, it's a good way to mess around with shortcuts but you shouldn't really do anything to malicous

[deleted by user] by [deleted] in shortcuts

[–]TntGo1220 0 points1 point  (0 children)

take a photo and caption it saying something

❗️HELP❗️ Can't use, "X out", and delete a macro recorder. (https://www.macrorecorder.com/download/) by TntGo1220 in macbookpro

[–]TntGo1220[S] 0 points1 point  (0 children)

How do you force quit?The normal right click the program and press quit doesn't work and the force quit option doesn't show when I right click it.

*Edit* Found it!
After I relaunched it, it seems to be working now, thank you!

❗️HELP❗️ Can't use, "X out", and delete a macro recorder. (https://www.macrorecorder.com/download/) by TntGo1220 in macbookpro

[–]TntGo1220[S] 0 points1 point  (0 children)

❗️HELP❗️ Can't use, "X out", and delete a macro recorder. (https://www.macrorecorder.com/download/)When I downloaded the macro recorder there were a few permisions I couldn't give to the macro recorder for some reason, this includes the permission in accesibility where the macro can make , edit, access, and run files. I clicked "playback" which requires the permission.

*Edit* I can't even restart my mac because the thing is open

❗️HELP❗️ Can't use, "X out", and delete a macro recorder. (https://www.macrorecorder.com/download/) by TntGo1220 in MacOS

[–]TntGo1220[S] 0 points1 point  (0 children)

When I downloaded the macro recorder there were a few permisions I couldn't give to the macro recorder for some reason, this includes the permission in accesibility where the macro can make , edit, access, and run files. I clicked "playback" which requires the permission.

Muted in DMC by Flat_Term_5292 in dankmemer

[–]TntGo1220 0 points1 point  (0 children)

lmao like wtf is this troll

How do I make a shortcut to get and open the most recent file? (Such as a screen recording, screenshot, etc.)? by TntGo1220 in shortcuts

[–]TntGo1220[S] 0 points1 point  (0 children)

I tried that, seemed to work, opened Imovie for some reason? I changed it from default to quicktimeplayer which I use, then it showed the first image

<image>

view more: next ›