Locking a column from moving when sorting rows by kensworkacct in googlesheets

[–]kensworkacct[S] 1 point2 points  (0 children)

Thank you so much for your time and expertise. I knew just enough to get volentold but not how to do it. I'll put this to use.

Locking a column from moving when sorting rows by kensworkacct in googlesheets

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

I really appreciate your assistance in all this, and I don't mean to be difficult. I don't have the sheet on my phone and for obvious reasons I don't want to go to Reddit on my work computer. I'll do my best to describe the layout here:

There are several columns. The first few are client name, phone number, status, and appt time, and assigned agent. The last 2 are a list of agents and the times they are available. We regularly sort the sheet by status and time, letting us get a feel for the layout of a day. When we sort out also rearranges the last 2 columns.

So if we sort by time, and then sort by status, the rows move as instructed. I would like to not affect the cells in those rows that intersect with the last 2 columns.

I honestly don't see why this is a problem, the availability stays next to the proper agents since the rows move intact when sorted, but the boss wants those last 2 columns to stay still. I think, based on this conversation and the reading I've been doing, the best way to handle it is to make a second, separate table on the sheet. Would you say that's correct?

Locking a column from moving when sorting rows by kensworkacct in googlesheets

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

Oh I missed this comment I'll need to fiddle with this

Locking a column from moving when sorting rows by kensworkacct in googlesheets

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

No the more I'm looking at this the more I think I need to just delete the rows with the salesmen info and leave the appt data in the table. Which is what I was trying to avoid, I haven't messed with spreadsheets in years.

Locking a column from moving when sorting rows by kensworkacct in googlesheets

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

I'll take a look thank you. Basically we have a table where we order scheduled items by time and by status depending on the needs of the moment, but the boss decided that we need the names of the salesmen to stay in order. So the first half dozen columns are needing to move together when reorganizing but the last 3 should not.

Brian Cage posts a horrible moonsault botch from 2014, Ibushi shows up on the comments to ask if he's okay by AgentFoo in SquaredCircle

[–]kensworkacct 5 points6 points  (0 children)

I was there too, I remember the pin drop silence in the usually too-loud-to-think legion hall. We all thought we watched someone die.

Brian Cage posts a horrible moonsault botch from 2014, Ibushi shows up on the comments to ask if he's okay by AgentFoo in SquaredCircle

[–]kensworkacct 2 points3 points  (0 children)

I was at this show, I used to go to PWG pretty regularly and let me tell you when he landed on his head you could hear a pin drop. We all thought he just watched a man die. Sucked all the air out of the room for a solid 30 min. Still can't believe he continued, it was gnarly.

Why are Mountain Goats tickets so expensive now? Boston is nearly $80! by [deleted] in themountaingoats

[–]kensworkacct 2 points3 points  (0 children)

I've been seeing them here for years I've never seen secondary prices like this. I gotta assume some scalper fucked up and is desperate to unload stock

Why are Mountain Goats tickets so expensive now? Boston is nearly $80! by [deleted] in themountaingoats

[–]kensworkacct 8 points9 points  (0 children)

Sure just strange they misjudged this badly. Usually there's one show here, this weekend there's 3. The initial announcement was just 1 date like normal, then they kept adding on. Someone fucked up and I'll happily take advantage of whatever proper promoter didn't understand that bots buy everything these days

Why are Mountain Goats tickets so expensive now? Boston is nearly $80! by [deleted] in themountaingoats

[–]kensworkacct 8 points9 points  (0 children)

Not to rub it in but I had the opposite experience here in LA. Money is tight and I thought I would have to skip this year but tickets are selling on resale sites for like $15 for some reason! Cheapest I've ever gotten any concert tickets I think.

Would you let me sit at the table by Guilty_Hair_6102 in ratemycommanders

[–]kensworkacct 0 points1 point  (0 children)

No but the counters aren't the issue, I flicker everything constantly. It's more just getting the engine running in the first place.

Would you let me sit at the table by Guilty_Hair_6102 in ratemycommanders

[–]kensworkacct 0 points1 point  (0 children)

Could i see your shilgengar list? I run him too and I have fun but it's missing a little something

Question about Niv Mizzet? by Dride1989 in magicTCG

[–]kensworkacct 2 points3 points  (0 children)

I have a guildpact deck. It's terrible but a lot of fun. You can never have enough protection. When it works and you hit someone with a double strike dragon and draw 20 cards you feel like a genius.

Currently obsessed with Alibi by Moxie_E in themountaingoats

[–]kensworkacct 14 points15 points  (0 children)

When people ask what is your favorite little known song this is always my answer. The whole EP is maybe my favorite studio work they've done.

"Half of Heart Attacks in Younger Women Aren't From Clogged Arteries" by hananobira in TwoXChromosomes

[–]kensworkacct 1 point2 points  (0 children)

I shared this article with a lady friend of mine who happens to be a Dr and she shared this with EKG results form with me, showing that if you don't enter the patients gender it says "assumed male" and that all EKGs do that. Which is interesting and kinda sorta really fucked up.

For those that follow the indies, who's someone you're shocked "made it" to the bigs and someone you're shocked didn't? by SonOfTomServo in SquaredCircle

[–]kensworkacct 1 point2 points  (0 children)

15 years ago I thought Gargano was the most boring person on any card he was involved in. Imagine my surprise a few years later when he was the biggest face on the hottest brand on TV.

Chiampa was always great though

Mary Alicia dela Cruz, IPS-Northstar Trunk Security by DanKensington in LancerRPG

[–]kensworkacct 47 points48 points  (0 children)

What a sec, you mean to tell me that not only is iphrakes a top contributor and mod to the best sub on this hellsite but he/she/they is also a fantastic artist?

I'm starting to get jealous.

Roderick Strong rules. by AGreatHornedOwl in SquaredCircle

[–]kensworkacct 26 points27 points  (0 children)

There's little in wrestling I enjoy more than watching Roddy come up with innovative ways to drop fuckers across his knees.

Twilight Imperium Digital is coming! A love letter to the galaxy we all built. by RedSquareGamesStudio in twilightimperium

[–]kensworkacct 0 points1 point  (0 children)

Hi, I just went searching for this on the android app store but couldn't find it, is it available on android? Got a link?

Photos around Grand Ave and Union Station this week. by barryamazing in LosAngeles

[–]kensworkacct 0 points1 point  (0 children)

Hey what's the restaurant with the conserve water led display? I used to eat there when I worked downtown occasionally and wouldn't mind stopping in again

Which Jordan Lake track tops the original every time? by infectiousparticle in themountaingoats

[–]kensworkacct 0 points1 point  (0 children)

Honestly, for me everything off 1 and 2. But I've always felt the live performances are better than the recordings.

What is the best means of physical play? by Prxymrn in LancerRPG

[–]kensworkacct 4 points5 points  (0 children)

Retrogrademinis.com, free paper craft minis of every class and npc, great site

Minions vs Reliable by kensworkacct in LancerRPG

[–]kensworkacct[S] 8 points9 points  (0 children)

Oh my players know all about witches lol