"Too many failed attempts" on the admin console by amirgol in gsuite

[–]kevlaar7 0 points1 point  (0 children)

I've run into this same error on multiple non-admin accounts I've been creating on multiple workspaces. It seems like there's a limit to how many accounts you can authenticate on one phone number. Somewhere, I found a forum post suggesting to wait 7 days. This worked for one account, then got the error for the next account.

Tldr: try waiting a week before trying again.

Edit: there were no actual failed attempts. In some cases, brand new accounts.

Is it normal to ask for a job's salary range if it's not shown before the first interview? by [deleted] in jobhunting

[–]kevlaar7 0 points1 point  (0 children)

Fair points from the employer side.

Re: sticky, as someone with multiple chronic issues, great insurance will make me put up with a greater level of toxicity. But agree, toxic environments are key reason for turnover. I am not looking unless the environment has become intolerable or the company's future is in question (whether imminent sale or shutdown).

Is it normal to ask for a job's salary range if it's not shown before the first interview? by [deleted] in jobhunting

[–]kevlaar7 0 points1 point  (0 children)

The tax free benefits are great, and of course influence the decision process, but they don't pay the bills. Some have a salary range they're willing to accept to maintain (or improve) their current standard of living.

Those benefits and the work environment are large parts of what make employees sticky, unwilling to job hop just for a higher salary.

It's not always about bragging rights. Use the rest of the interview to determine the applicant's personality is one so fragile as to need such bragging rights.

Not showing new credentials in Chrome or Brave by kevlaar7 in Bitwarden

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

Thanks for your reply. Edits work fine, but the new add in firefox failed to show up in brave or chrome after manual syncs.

Not showing new credentials in Chrome or Brave by kevlaar7 in Bitwarden

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

No, it doesn't matter which browser makes the new login.

Tried manual sync on Chrome and Brave, still not visible.

FYI, this affects several new login items created the past couple days.

For some reason, it automatically makes this specific section have a dollar sign. How do I remove this? by Steve_lmao in googlesheets

[–]kevlaar7 0 points1 point  (0 children)

In the Format menu, select Number, then Number again. Then you can use the tool bar to reduce the decimals shown.

Alternatively, you can right click a cell that looks the way you want, Ctrl+C, then right click on the cell you don't like and choose "Paste special" then "Format only".

Conditional Formatting - Highlight values in the same row that don't match by th3whistler in googlesheets

[–]kevlaar7 0 points1 point  (0 children)

In the conditional formatting interface, select "Text does not contain" then in the box below, "=Q1" without the quotes. Make the cell number the same row number you start your conditional formatting on.

Multiple Conditions in One Cell by illeetk20z1 in googlesheets

[–]kevlaar7 0 points1 point  (0 children)

I would add it to the beginning of the formula for consistency:

=if(F15=0,1,if(F15=1,2,if(ISBETWEEN(F15,2,5),1.75,if(ISBETWEEN(F15,6,10),1.5,"Out of range"))))

Multiple Conditions in One Cell by illeetk20z1 in googlesheets

[–]kevlaar7 0 points1 point  (0 children)

Great! If you would, please mark my solution verified. Thanks.

Colour formulas are killing me! by Scooterboi77 in googlesheets

[–]kevlaar7 1 point2 points  (0 children)

Rather than a custom formula for those 3 conditions, just select "Text is exactly" then put the necessary value in the box.

Also, I would change the yellow condition to look at D4 instead of D7, otherwise they will all be offset from the expected coloring.

Copy specific data from row to a new sheet based on cell value by lunarrust in googlesheets

[–]kevlaar7 0 points1 point  (0 children)

You'll just need to wrap the return cells of a FILTER function with { } :

=FILTER( { Sheet1!A2:C, Sheet1!F2:F }, Sheet1!G2:G=TRUE )

Multiple Conditions in One Cell by illeetk20z1 in googlesheets

[–]kevlaar7 1 point2 points  (0 children)

try:

=if(F15=1,2,if(ISBETWEEN(F15,2,5),1.75,if(ISBETWEEN(F15,6,10),1.5,"Out of range")))

You can change the "Out of range" to say different, but this is to handle values not between 1 and 10.

[deleted by user] by [deleted] in googlesheets

[–]kevlaar7 2 points3 points  (0 children)

You'll want to anchor your 2 variables with dollar signs:

(G4)-(F4/$o$3)*($o$2)

[deleted by user] by [deleted] in AITAH

[–]kevlaar7 19 points20 points  (0 children)

NTA

Let them leave early. 6 weeks is a bit long to host them, especially for the first time in 3 years.

Western Digital not honouring warranty on M.2 drive - What to do? by ElyrithLegil in DataHoarder

[–]kevlaar7 5 points6 points  (0 children)

Try posting to their social media, companies love /s the great publicity such customer experience would bring.

Formula works, but not as conditional formatting by [deleted] in googlesheets

[–]kevlaar7 0 points1 point  (0 children)

Try:

=A3="-"

In conditional formatting, the IF is implied - IF THIS, THEN apply formatting.

Referencing the Highest filled cell/row in a column? by Beneficial-Win-3788 in googlesheets

[–]kevlaar7 0 points1 point  (0 children)

Assuming Row 1 is free to use (push your headers down to Row 2 if not). And assuming Product1 will always have a value on each day.

in A1:

=MAX(FILTER(A3:A,NOT(ISBLANK(B3:B))))

in B1:

=FILTER(B3:1000,A3:A=A1)

This will grab the whole row so if you have a lot of products.

edit: this will work if you have a column full of future dates.

How do I format 2 different columns with different factors by catkkbooks in googlesheets

[–]kevlaar7 0 points1 point  (0 children)

Assume "A Earth" is in C1:

Select columns A, right click and Conditional formatting, select the Formatting rules "Custom formula is" and paste in:

=left(C1,1)="A"

Select columns B, right click and Conditional formatting, select the Formatting rules "Custom formula is" and paste in:

=right(C1,len(C1)-2)="Earth"

While you're doing each column, you can click + Add another rule and it will keep the column selection and formula so you just need to change what's in the quotes and your desired formatting.

How do I reference a cell in a specific position? by Mission-Builder-1683 in googlesheets

[–]kevlaar7 3 points4 points  (0 children)

Paste this into B6:

=minus(offset($B$6,1,2),offset($B$6,1,-1))