{ "media_type": "image", "post_content": "Fun tip of the day - you can use dynamic array functions (sort, filter, unique…) to easily create dynamic drop downs for data validation or cascading dependent choices (i.e. cell B2’s drop down updates based on choice made in A2). The trick is to add a hash after the cell containing the dynamic array in data validation source and it picks up the whole array. Good lesson here: https://www.excel-university.com/dependent-drop-downs-with-filter/", "post_id": "6101615aa75fd60021d936a2", "reply_count": 1, "vote_count": 12, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius" }
Posting as :
works at
You are currently posting as works at

An additional use case I’ve found is that I keep a list >50pp for staffing purposes and have a column recording their availability. I assign a long set of workstreams to people data validated on the staffing list filtered by availability. Now, when I update the available list, I can just “circle invalid data” to show me all the workstreams that I need to reassign.

Related Posts

How do I create effective lesson plans?

like

Does anyone have a coworker on their team that never submits their lesson plans on time? Do you plan for all of the subjects you teach? Or is each team member responsible for a subject?

like

Yesterday was a good day. I was really impressed with myself. I woke up at 5, practiced dance lessons, did two water colors, made breakfast and tea, got to work by 10, put in 8-10 hours of solid work and then came home. It’s been ages since I painted or danced. However today, I slept till 7:00, did not work out or have food. Still got to work by 10 and did 8 solid hours of work. Some days are good and some are just okay. And that is okay. Trying to build on my good days and we all can. :)

likeuplifting

I need a deck on House of Cards' lessons learned on how to apply the Underwood's strategies and scheming in consulting.

like

If you don't ask for it you won't get it. Lesson learned.

like

Any ladies here golf? I just bought a home in a golfing/lakeside community and now want to pickup the sport. Any deets on where to but cute golfing outfits/shoes? Tips on getting started? Planning on setting up a few lessons soon…TIA

like

On Monday, we'll have like an hour to go into our classrooms to get anything we need to start making lessons for distance learning. what do i need?

like

What lessons did your parents teach you about finances/money before you went off to college?

like

I’m glad I learned my lesson the first time (May drop) and started shaving profits on this latest run

like

We just started using the Classroom Assessment Scoring System in our programs to measure quality of interactions and lesson plans. I think it's been one of the most meaningful tools for providing feedback to teachers.

like

I've been teaching astronomy and running the school planetarium for 5 years now. Just thought it would be nice to share lessons or planetarium shows with others to generate new ideas

What’s the most important lesson you’ve learnt managing people that you would pass down to a new Manager?

like

What's a valuable life lesson you had to learn the hard way?

like

What’s the most important lesson you learned in consulting?

like

Got an email “reminder” that weekly lesson plans are due Monday morning. I’m tired. I want to reply “no” because I don’t have time to make detailed lesson plans on their template...for lessons that I won’t follow...for a curriculum they haven’t given me yet....But I should probably just ignore it until I’m less tired so I don’t let my mouth get me in trouble. Do y’all turn in lesson plans?

likehelpfulfunny

I'd love to connect with other elementary librarians to discuss lesson ideas, class management styles, etc.!

Favorite Ted Lasso lesson?

likefunny

Any recommendations for golf lessons in the Chicago area?

Favorite online or printable lesson plan format that works for high school periods and not just elementary teachers?

like

Additional Posts

Would anyone at Deloitte be willing to provide a referral? I’m qualified for the role but just want to ensure my resume gets seen. TYIA

like

Making decent money and my husband and I are starting IVF. I went from feeling ok financially to pretty concerned. Insurance only contributes 15k that’s it. I’m trying to decide how I feel about taking out a loan. Is it wise? Any IFV folks with a perspective?

like

Anyone at Deloitte have some insight on the Strategic Communications and Change Management positions for analyst and consultant? What to expect in the final interview? Base salary + bonus? WLB? Asking for a relative! Deloitte

like

I need to schedule two 2.5 hour interviews this week. Should I schedule them on the same day or take 2 mornings off? What’s the least obvious?

like

When you were telling your senior manager & partner about problems with a client for months but they didn't care. Now you've roll off forever, it's busy season, and the office lead partner is pissed.

Post Photo
likefunny

Thoughts on EU ruling on Uber being a taxi firm > US impact? Sounds legit. Don't care much for their corporate culture, but care less for the high prices and poor service of regulated taxi firms

like

What’s the salary range like at EYP for an SC position? Also, how many years in consulting do they expect for those applicants?

like

Hello has anyone interviewed for Linkedin BizOps team or Uber Ops and Logistics Manager? Would appreciate tips! Also how do you guys typically prepare for interviews with small series B startups?

like

I’m a lazy investor and don’t want to think about my money, so I invest my Roth IRA and 401K into a Vanguard target fund (2065). Should I be doing more with my money?

like

Interview tips for creatives?

like

Looking to exit to a tech company - has anyone ever approached a DEI person at the company you are applying to on LinkedIn? Is this something worth pursuing or should I just apply directly?

like

Any recommendation of book to crack a case study? MBA course case study and real life firms case study?

like

Is 1.68 for a townhouse is expensive for house hold income ~600k? we can do 20% down. I am just nervous as we are in the hook for $7.5k mortgage every month including property tax, hoa and insurance. Just can’t seem to decide or let go!

like

5.5 months pregnant. I’ve been having some insanely vivid dreams about breastfeeding my future baby. Weird

Seeking AE for independent shop in LA. Currently remote with ultimately a hybrid return (date tbd). Please message me if you’re interested!

like

MBBers, how did y’all prepare for case studies / interview process? Any discerning difference between how Big4 interviews are conducted?

like

H1b extension - where does USCIS send the receipt? Does it go to your lawyers address? Or do you get it directly?

like

Hey fishes! I’m looking to make the move back to Chicago this year. I’m mid-level now, recently promoted. What’s that salary level like in Chicago? And senior? Thanks a mil!

like

Hi Fishes, Recently I had got an offer from KPMG (less technical, BLR) with 70% hike; So I resigned from TCS with a Wings1 DCA result pending; After a couple of weeks, I got to know my DCA is approved,80% hike in KOL; So I withdrew my resignation... Now since I am staying with my parents and I would be left with some extra time that I can devote to my skill-upgradation; Request you all to suggest me how should I proceed to more tech role?🙏🏾 Scaler academy or any other certifications?

like

Can someone please help me navigate concerns about the vaccine? Literally all I hear from Fox News zombies saying big pharma and Bill gates are pushing the vax for personal profits only and Covid is not that deadly. What has worked with those in the inner network circle? What hasn’t? My pregnant wife who is nurse received both doses and I think a couple relatives believe the baby is going to be a cyborg.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal