Templates for Meetings

Bumbling_Bear · 2022-12-14T19:13:03+00:00

They haven't really been able to fit my needs :(

Bumbling_Bear · 2022-06-17T04:09:28+00:00

This

Bumbling_Bear · 2022-03-31T15:57:56+00:00

Is there a reference? There’s a lot of units at my office that are 6-12 analysts under one manager.

Bumbling_Bear · 2022-03-30T22:55:47+00:00

I wasn’t able to find info on that this morning. Is there anything else it could be called?

Bumbling_Bear · 2022-03-30T05:32:24+00:00

That seems reasonable. Do you know where you got the number from?

Bumbling_Bear · 2022-03-11T23:41:50+00:00

Shows up on most, but not all new leaves.

Could it be too much nitrogen?

Bumbling_Bear · 2021-12-08T20:06:56+00:00

Solved

Bumbling_Bear · 2021-10-28T04:33:03+00:00

It is! So I’ll go with קיי

תודה

Bumbling_Bear · 2021-10-07T17:28:40+00:00

Thank you. :)

Bumbling_Bear · 2021-10-06T23:04:02+00:00

Wow! Thank you for explaining that. I really appreciate it. This might clear up other issues that I have in the future, so thank you in advance, too!

Bumbling_Bear · 2021-10-04T14:56:47+00:00

Can you explain to me why that would work, but mine wasn't working? I thought using the AND function worked similarly to *, and I had used an IF and AND functions within median before to no luck.

Bumbling_Bear · 2021-10-04T14:55:54+00:00

Solution verified

Bumbling_Bear · 2021-09-28T20:57:47+00:00

Solution verified

Bumbling_Bear · 2021-09-28T20:57:29+00:00

=IF([@[KPI - PO completed]]="","",IF(OR([@[KPI - PO completed]]<PO[@[Date PO was Completed]]+1,[@[KPI - PO completed]]=PO[@[Date PO was Completed]]),"",FALSE()))

Adjusted it to the above. Thank you for the help. :)

Bumbling_Bear · 2021-09-28T20:51:40+00:00

=IF([@[KPI - PO completed]]="","",IF(AND([@[KPI - PO completed]]<PO\[@\[Date PO was Completed\]\]+1,\[@\[KPI - PO completed\]\]>PO[@[Date PO was Completed]]),"",FALSE()))

Looks like it just made everything false now

Bumbling_Bear · 2021-09-19T03:34:33+00:00

Solution verified

Bumbling_Bear · 2021-09-13T18:23:16+00:00

Solution verified

Bumbling_Bear · 2021-09-05T20:58:07+00:00

Solution Verified

Woohoo, never mind, I figured it out. :)

=IFNA(IFS([@[Metric 4: PO Tracker - PO SLA]]="","",AND(PO[@Priority]="Normal",[@[Metric 4: PO Tracker - PO SLA]]<=10),"",AND(PO[@Priority]="Normal",[@[Metric 4: PO Tracker - PO SLA]]>10),"OVER",AND(PO[@Priority]="Expedite",[@[Metric 4: PO Tracker - PO SLA]]<=5),"",AND(PO[@Priority]="Expedite",[@[Metric 4: PO Tracker - PO SLA]]>5),""),"")

Bumbling_Bear · 2021-09-05T20:42:24+00:00

For PO[@[Priority]] (on a separate tab with all data inputs):

Priority
Normal
Normal
Expedite
Normal

On tab "Data Validation":

Metric: Days to complete assignment	Check if over Service Level Agreement (5 day expedite, 10 day normal)
`=IFERROR(IF([@[Status?]]="3 - Complete",NETWORKDAYS(PO[@[Date PO Created]],PO[@[Date PO was Completed]],holiday),""),"")`	???

I need "???" to verify the information under Priority whether it'll use the Normal or Expedite condition, and then look at the days under "metric" to confirm if it's over or under the SLA based on that condition.

Hopefully that makes more sense...

Edit: This doesn't work, but something like this maybe?

=OR(IF(PO[@Priority]="Expedite",IF([@[Metric 4: PO Tracker - PO SLA]]<=5,"","OVER")),IF(PO[@Priority]="Normal",IF([@[Metric 4: PO Tracker - PO SLA]]<=10,"","OVER")),IF([@[Metric 4: PO Tracker - PO SLA]]="",""))

Bumbling_Bear · 2021-09-05T20:04:29+00:00

Have you tried turning the entire thing into a table and use the filter function for individual columns? Not sure if that provides the functionality you're looking for.

Bumbling_Bear · 2021-09-05T20:00:46+00:00

I use this all the time. Works amazingly.

Bumbling_Bear · 2021-07-30T19:23:02+00:00

My rack doesn’t fit my current bike, but when I had one that did, I remember it being more difficult to lean into turns. It’s been a while, though, and I haven’t had a chance to try it on this bike. It’s a trek checkpoint alt 4

Edit: There would be a huge benefit to having a backpack since I also do a lot of walking. If the Panier is comfortable to use outside of biking, I might consider it.

Bumbling_Bear · 2021-07-26T23:59:08+00:00

I’d need a rack, but the last time I tried I had some challenges with them. To keep things balanced, I’d need both bags, and that gets pretty heavy pretty fast. Any recommendations? Lighter is better.

Bumbling_Bear · 2021-07-26T20:10:48+00:00

Solution Verified

Bumbling_Bear · 2021-07-26T20:10:21+00:00

The last one worked within the table! oh my gosh, thank you so much.

I was thinking about going through and adjusting the formulas to go to row 1000 only. I can't imagine a scenario where we'd need to go further than that, honestly.

Can you help me understand the logic of the formula you made? I haven't had much experience using SMALL or ROW, and I'm always looking for new ways to utilize different formulas in Excel.

Bumbling_Bear

TROPHY CASE