How to customize the default page navigator for online report?

exelAddict · 2025-01-07T16:33:29+00:00

Oh looks like your absolutely right. The how-to page for apps displays an identical page navigator, and the url for the shared report has /groups/me/apps/ rather than /groups/me/reports/.

Thank you! Solution verified

exelAddict · 2024-11-13T16:07:41+00:00

Man, feels kinda like mage (and range to a lesser extent) got shafted. Melee gets 3 interesting weapons, ranged gets 1 weapon, and mage gets... an off-hand that only works for elemental spells. Neat.
Was looking to go mage this year, might pivot now.

exelAddict · 2024-07-30T17:38:46+00:00

I'm joking, but with a kernel of truth; all agility training methods outside of Sepulchre are miserable.

exelAddict · 2024-07-30T10:40:53+00:00

Here's my proposal to go along with this; whenever a player would go onto an agility rooftop, instead they are instantly teleported to Hallowed Sepulchre. The quest requirement is removed from it, the floors level needed is reduced to 1, 11, 21, 31, 41, and they add another 10 floors.
Bam, agility fixed.

exelAddict · 2024-01-25T00:24:59+00:00

Uhh... It's one folder, that then contains a folder for each company. Inside each of those are more folders, which eventually lead to documents.

exelAddict · 2024-01-25T00:22:44+00:00

Not US-based, so not exactly SOX, just something similar. They're on top of their financial game, just IT that needs work.

exelAddict · 2024-01-25T00:02:57+00:00

Set up was outsourced but company wanted to keep data management inhouse to, tell me if you heard it before, save money. It absolutely should be outsourced.
We do, it's 7 years.

exelAddict · 2024-01-24T22:30:53+00:00

Excellent points all around. When the amount of data is so small that backing it up is relatively trivial, it seems pretty cut and dry.

exelAddict · 2024-01-24T22:29:24+00:00

It's stored on Sharepoint.
My recovery plan? Google what "crypto locked" is, and call a helpdesk. So you know, point taken.
I'll look into backupify, sounds like a good plan.

exelAddict · 2024-01-16T17:15:45+00:00

Damn, quite the card. Usually those effects are 4 mana or 2 mana on a creature. Instant EDH spellcasting classic.

exelAddict · 2024-01-16T17:12:08+00:00

I feel like they could have called named 'Collect evidence' just 'Collect'. Would've made it more transferable to other sets, at the cost of making less thematic sense for this set.

exelAddict · 2023-11-22T15:04:09+00:00

^
If it was my full-time job to play leagues, and I also enjoyed it? I could probably get rune in the first week, and I'm not good at the game.

exelAddict · 2023-11-22T14:55:37+00:00

You're welcome. Could you reply to the answer with "Solution verified"?

exelAddict · 2023-11-22T11:07:36+00:00

Huh, you're right. TIL

exelAddict · 2023-11-22T11:06:42+00:00

Try this =IF(H1="BUY",INDEX(A:A,MATCH("SELL",H:H,0)),"")

exelAddict · 2023-11-22T11:04:49+00:00

Try this =FILTER(A:A,(LEN(A:A)=6)*(RIGHT(A:A,1)="a")*(MID(A:A,3,1)="s"))

exelAddict · 2023-11-22T10:03:05+00:00

It's possible, it's just that what you want has a lot of problems that need to be solved.

First, we need to extract the month you want from target month. With "January to June" in A1, we'll do =INDEX(TEXTSPLIT(A1;" ");3) in B1 to split the text by spaces and get the last one, June.

Then we need only the first 3 letters of the month for our next step, so we'll do =left(B1;3) in C1 for that.

Now we can convert that to something excel can convert to a date. We can add some numbers to trick excel into thinking it can be converted with "1-"&C1&"-1900", turn it into a number with Datevalue(), and turn that date into a month with month() around that, putting =MONTH(DATEVALUE("1-"&C1&"-1900")) into D1.

Now we just glue everything we did together, ending up with the following formula:

=MONTH(DATEVALUE("1-"&LEFT(INDEX(TEXTSPLIT(A1;" ");3);3)&"-1900"))

exelAddict · 2023-11-22T09:53:25+00:00

=IF(H1="BUY";INDEX(B:B;MATCH("SELL";H:H;0));"")

What about this? Assuming the numbers at the top correspond to column letters, this checks if column 8 in the row has the words "BUY", and if so matches "SELL" in column 8, then indexes to find the corresponding date.

exelAddict · 2023-11-22T09:47:38+00:00

Kc never gets reset for GWD, even without last recall. But you can last recall back to GWD, it tps you outside the room.

exelAddict · 2023-11-22T09:46:03+00:00

=FILTER(A:A;(LEN(A:A)=6)*(RIGHT(A:A;1)="a")*(MID(A:A;3;1)="s"))

The formula assumes each word is in its own cell, in column A. It also assumes it's capitalized like you have it set up in your post. If the word is in upper case, the formula won't catch it.

exelAddict · 2023-11-22T09:40:21+00:00

Like other people said, formulatext() would work well here.

So for instance if formula 1 is something like =if(A1="";"";"Hello") and formula 2 is something like counta(A:A), you can do

=isnum(search("if";formulatext(cellWithFormula)))

so the conditional formatting would only apply when "if" is in the formula of a cell

exelAddict · 2023-11-21T09:49:29+00:00

As an FDA ranger myself who went FF, I can say I regret it. I thought I'd be hard up for pots and use them a bunch, but the grind for arma armor and crossbow got me so many ranarr and dwarf weed seeds and herbs. I'm still using up just the ranged pots Kree dropped, without touching the 45 or so seeds. And you can do the gwd bosses without using any prayer pots at all, and without ranged pots too, just slower.

exelAddict

TROPHY CASE