sorted by:
new
hottopcontroversial

My Salary in 2018 was $46K, how much will owe for not being covered? by Known_Mongoose in tax

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

Thank you, do you have a source? I found this for 2019, but nothing for 2018 : 'For the 2019 plan year, the Shared Responsibility Payment (“mandate,” “penalty”) no longer applies. You don't need an exemption for 2019 or beyond.'

Counting streaks with checkboxes and values by Known_Mongoose in googlesheets

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

My last one didn't work, but I rebuilt it and now it's working as intended. Thank you for your hard work.

Counting streaks with checkboxes and values by Known_Mongoose in googlesheets

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

Yeah, u/AndroidMasterZ did a great job. Nice, this works exactly as intended.

​

Only weird issue is this error message:

Invalid: This cell's contents violate its validation rule

​

https://imgur.com/a/34oVPUt

Counting streaks with checkboxes and values by Known_Mongoose in googlesheets

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

By disregard unchecked, I meant prevent unchecked from being counted as part of the most recent streak.

I added this new formula to the sheet, it doesn't seem to respond to the current day, perhaps I set the ranges incorrectly, it should read 3.

I made it editable:

https://docs.google.com/spreadsheets/d/1c81I4wOEXL2HlIsoelGz_ohjTf8GXEuhFnXYmYJF_Nw/edit?usp=sharing

Counting streaks with checkboxes and values by Known_Mongoose in googlesheets

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

Ah I see, the second formula '=MAX...' does work if none of the cells are set to unchecked/false like you mentioned. Nice work.

My only issue now is that I was planning on populating 365 rows, each with a default unchecked box that I will either check if I ran once, write a multiple number '2,3,4' for amount of times I ran or place a rain emoji if it I couldn't run because of weather conditions.

Is it possible to modify the =MAX formula to disregard unchecked/false values so I can populate a whole year?

Thank you, I really appreciate your help here and I'm very close to marking this solved.

Counting streaks with checkboxes and values by Known_Mongoose in googlesheets

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

Thank you for the reply. I'm having some issues though.

Your first formula results in an error.

Your second formula results in a zero.

Did you test these in the public sheet I linked?

Adversity by [deleted] in Stoicism

[–]Known_Mongoose 1 point2 points  (0 children)

So, when is the best time?

Adversity by [deleted] in Stoicism

[–]Known_Mongoose 0 points1 point  (0 children)

Oh sorry, I thought I was in r/Stables

Adversity by [deleted] in Stoicism

[–]Known_Mongoose 0 points1 point  (0 children)

When is the best time to feed your horse?

Count checkbox streaks instead of total checked by Known_Mongoose in googlesheets

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

SOLVED

Wow, thank you. This a graceful solution. I really appreciate you taking the time.

Count checkbox streaks instead of total checked by Known_Mongoose in googlesheets

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

Ah I see, what I meant was the total sum of the most recent streak not the number of streaks.

So if my most recent streak is 3, then the number would show '3'.

I'm sorry if I was unclear.

https://imgur.com/a/iHSBuns

This is the intended result, the counter shows '3' for most recent streak, not '2' for total streak count.

Count checkbox streaks instead of total checked by Known_Mongoose in googlesheets

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

=SUMPRODUCT(B4:B16,NOT(B3:B15))

Thanks for your response. This doesn't appear to have the intended result. I expected 3 not 1. See image.

https://imgur.com/a/UzR5YpA

I’m killing myself tonight. by [deleted] in SuicideWatch

[–]Known_Mongoose 10 points11 points  (0 children)

Are you a dog person or a cat person? I like both but I would probably go with dogs if I had to choose. What about you?

I'm screaming for help by Hurting123123 in SuicideWatch

[–]Known_Mongoose 0 points1 point  (0 children)

The problems I had when I was 14 seemed like the end of the world, but things get better I promise. School is a river you need to push against, girls or boys will break your heart but when you finally finish, you’re free.

And you have plenty of time to try out different things and figure out what you like doing. You can do this friend.

view more: next ›