Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch
or for an ad-free Fetcheveryone experience!

What really grinds your gears?

1 lurker | 185 watchers
Jun 2022
2:13pm, 5 Jun 2022
70,385 posts
  • Quote
  • Pin
Diogenes
Me.
Jun 2022
2:33pm, 5 Jun 2022
4,824 posts
  • Quote
  • Pin
Fields
Colleague who has removed all the formulas from a complex excel spreadsheet. She doesn’t know what she’s doing and I expect she never will
Jun 2022
4:59pm, 5 Jun 2022
16,655 posts
  • Quote
  • Pin
JK *chameleon*
[I've got one of those, Fields. Stripped out my formatting and made a bloody mess of a simple task]
Jun 2022
6:02pm, 5 Jun 2022
5,776 posts
  • Quote
  • Pin
Hunkyteddy
The amount of adverts on YouTube is making it unwatchable. And no, I'm not paying for the premium service
Jun 2022
6:39pm, 5 Jun 2022
4,827 posts
  • Quote
  • Pin
Fields
[JK - I will ask the owner of the spreadsheet if she can make them non editable but not sure that’s possible as sometimes we need to change the cells the formulas reference depending on the scenario - and that isn’t something we can build into the formula using IFs]
um
Jun 2022
6:46pm, 5 Jun 2022
6,143 posts
  • Quote
  • Pin
um
[Fields - the owner can protect the specific formula cells with a password - shared to others if wanted. Not shared with those not to be trusted. Post on the spreadsheet thread if you want help, or 16 different opinions ;-) fetcheveryone.com/forum/spreadeveryone-the-fetchland-excel-wire-47111/ ]
Jun 2022
7:07pm, 5 Jun 2022
4,830 posts
  • Quote
  • Pin
Fields
[Cheers um - the problem is every user will have a genuine need to amend the formulas - sometimes - to target a different cell depending on a particular scenario. So the only solution I can see is the user having enough access - and knowledge - to overtype C12 to F24 or whatever. They have the access but not the knowledge currently. I did think about asking on the excel thread but Nested IFs - which is what I think will be suggested - are not the solution - for reasons to complex to explain concisely]
Jun 2022
8:07pm, 6 Jun 2022
8,286 posts
  • Quote
  • Pin
Surrey Phil
The number of Excel spreadsheets I create with formulae and Word templates which people tamper with is incredible. You create the form, use developer tools and protect it so they only have to complete certain areas yet someone ends up changing everything because they think that headings and sections need touching up (which they don't) and mess it up for everyone else. Then I have to fix the mess because no-one else is capable.
Jun 2022
8:35pm, 6 Jun 2022
16,660 posts
  • Quote
  • Pin
JK *chameleon*
Not only has nice Admin girl messed around with my simple Excel sheet for tracking allocated work, but she's also allocated a load of work to someone who doesn't work on Mondays. That was a fun half hour fixing her mistake.
Jun 2022
11:10am, 7 Jun 2022
9,096 posts
  • Quote
  • Pin
GordonG
people who use Americanisms that only serve to confuse things. Example: i was asked by email today whether, when a form is returned to a team, they can "check it". I was just about to reply that there probably wasn't a need to review its accuracy when i realised they meant "tick it".

About This Thread

Maintained by Corrah
A forum to sound off about what really grinds your gears.
  • Show full description...

Related Threads

  • gripes
  • mundane
  • sofa

Report This Content

You can report any content you believe to be unsafe. Please let me know why you believe this content is unsafe by choosing a category below.



Thank you for your report. The content will be assessed as soon as possible.










Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,405 Fetchies!
Already a Fetchie? Sign in here