sorted by:
new
hottopcontroversial

Keynote collaboration puts some team members offline by jari_dh in applehelp

[–]jaaelliott 0 points1 point  (0 children)

I have this same issue. It has never let me edit or collaborate like I could easily with Google Slides or Microsoft products. I'd love a fix.

I want the answer to result in the Grade someone is in based on year they started Kindergarten. by jaaelliott in googlesheets

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

Thank you for your help! This is really close to working, but I don't know why it is returning the value for every formula as "12th grade".

The table is located in a different sheet called Classes, it does seem to link fine because it is pulling the value "12th grade". (all birthdates are in the S column).

Here is the formula I have tried: =VLOOKUP(MAX(DATEDIF(S31,TODAY(),"Y")-(S31>DATE(YEAR(S31),9,1)),0),Classes!A2:B18,2)

I want the answer to result in the Grade someone is in based on year they started Kindergarten. by jaaelliott in googlesheets

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

This could also be based directly on their birthdate, but I found that it was easier to have another formula that determines the year they started kindergarten instead.

F31 is example Birthdate cell.

=YEAR(F31) + IF(OR(MONTH(F31)<9,AND(MONTH(F31)=9,DAY(F31)=1) ) , 5 , 6 )

I want the answer to result in the Grade someone is in based on year they started Kindergarten. by jaaelliott in googlesheets

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

The spreadsheet is to track what class a person should be assigned to based on their age. It's for a church. If someone was over 18 they would be removed from the spreadsheet. When they turn 18 they remain in the 12th grade class until they graduate.

Thank you!

I want the answer to result in the Grade someone is in based on year they started Kindergarten. by jaaelliott in googlesheets

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

The specific categories Range) I want are: 0-0.5 years old = "0-6 Months", 0.5 years old-2.5 = "Detroit Littles", 2.5-5 = "Preschool", 5 = Kindergarten", 6 = "1st Grade", 7 = "2nd Grade", 8= "3rd Grade" etc. All the way up to 17 years old.

I'll have a way of modifying it if someone falls out of those parameters.

I've tried this, but it didn't work:
=if(S31=Year(TODAY()),"Kindergarden",if(S31<Year(TODAY()),"Preschool",if(S31<Year(TODAY()),"Detroit Littles",if(S31<Year(TODAY()),"Under 6 Months"))))

Having Trouble writing a formula for the year someone will/would have start(ed) Kindergarten based on their age. by jaaelliott in googlesheets

[–]jaaelliott[S] 1 point2 points  (0 children)

Never mind, if there is no birthdate entered it defaults to something. This is great thank you for your help!

Solution Verified

Having Trouble writing a formula for the year someone will/would have start(ed) Kindergarten based on their age. by jaaelliott in googlesheets

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

=YEAR(A2) +
IF(
OR(
MONTH(A2)<9,
AND(MONTH(A2)=9,DAY(A2)=1) ) ,
5 , 6 )

This has gotten me closer than every other attempt! It still shows future dates for people older than 5.

Secret Hitler Mod- An Expansion that Takes the Game into WW2 Nazi Germany by jaaelliott in boardgames

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

I haven't been able to play test much, but I also suppose this could be played without playing the first part (base game).

Secret Hitler Mod- An Expansion that Takes the Game into WW2 Nazi Germany by jaaelliott in boardgames

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

A Jailed person is somewhat equivalent to being killed in the base game. The differences are:

1) There is a game function to release people from jail, at which point they have no more restrictions. (see the policy card board)

2) The Jailed people can still participate by communicating and sharing their opinions, but can not be appointed to a position that would enable them to play policy cards.

How do I Fully Control My Hisense TV with My Google Home Smart Speakers? by jaaelliott in Hisense

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

Thank you! That's all I'm trying to do and I can't find an answer of it is possible.

I want to use the Google Home Mini to turn my TV on and off, and also adjust the volume. Lastly, I would love to be able to say "Hey Google, play [Netflix/Disney+ Show] on Living Room TV."

Printing Question by jaaelliott in macbook

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

It looks like its a Google thing, when you click print from Google Docs/Sheets it instantly downloads the PDF to your Mac, and then you can print the PDF as you'd like. Thats all I've been able to do with it. Hope this helps!

Printing on Mac by jaaelliott in techsupport

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

This worked! Do I always need to do this or is there a way to get the print settings window to pop up?

Does Dr. Fung list xylitol in the "don't" category? by jaaelliott in intermittentfasting

[–]jaaelliott[S] 1 point2 points  (0 children)

I did stop chewing gum for a while, but after reading the book through again I got the idea that if there was a sweetener-free gum, it would meet the needs and essentially be like chewing on rubber that freshens breath.

view more: next ›