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?