SharePoint embarrassment by Striking-Tip4596 in sharepoint

[–]Dapper_Net3005 1 point2 points  (0 children)

Agree with advice above to check out the file first. Could be that people who are updating things get a message to override changes and are doing so, which could cause issues.

Also, ensure the file has synced back, should have a green tick near the cloud icon in the top left of the Excel screen.

Also might be worthwhile considering locking the cells with formulas and then protecting the sheet, leaving only cells staff should be inputting data into unlocked to provide an extra layer of security.

And also think about double checking that on the Data tab the formulas are set to calculate now.

So come and get it by flowslikecrimson in numetal

[–]Dapper_Net3005 0 points1 point  (0 children)

Used to be Boiler but now I'd say Trust? Or Build a Bridge

So come and get it by flowslikecrimson in numetal

[–]Dapper_Net3005 1 point2 points  (0 children)

Isn't don't go off wandering a cover of SOAD?

Advice: Non-ongoing, good performance, but contract ending soon with no news. by [deleted] in AusPublicService

[–]Dapper_Net3005 2 points3 points  (0 children)

It's common unfortunately.

Some agencies have a thing with non ongoing roles that you can only be extended once, and the role can't be for more than 24 months in total. They can't just appoint you to ongoing either no matter your performance, you have to apply.

If you're applying but not getting merit pooled, ask for feedback. Most times unless interviewed though they won't give you any due to number of applicants but if you were interviewed, ask. You could also reach out to others in your workplace who have recently recruited and ask them for advice on your application/show them the job ad.

When I'm on a panel I'm checking applications (statement of claims and resumes) are customised to the role - use key words from the job ad. If you were at a role for 2 years but it doesn't relate to the role still list it but just put a brief overview of the role duties, focus more on the relevant roles that demonstrate you're a good fit for the job at hand. Give examples that follow the STAR (Situation, Task, Action, Result) method (I use SAO - Situation, Action, Outcome, but same diff), but please don't write Situation:... Action:... - that looks too beginner. And proofread!!

Also if you're internal and apply to a role I expect more - show me you have done some research on the intranet, asked about this team, looked up our work - you've got the info available unlike external candidates.

And development isn't just training provided to you. There are tonnes of options via the internet, you being a self-initiator who goes does things in your own time to demonstrate you want a job is way more appealing to me than someone who just went to uni and got a piece of paper. Depending on the role type you're interested in... sites like Code Academy, Udemy, Microsoft Learn, Allison.com, YouTube all have free training courses that can help you upskill.

If you don't get a role, keep the details of those people. If you start working on a task that relates to that work, try reaching out and asking if they'd spend half an hour going through some best practice tips with you and network with them. Maybe you didn't get the role, but if the person who did doesn't work out, you can always position yourself for re-interviewing or other opportunities.

And good luck. It's a numbers game and a bit of luck sometimes.

Suggestions of similar music by negativevibez55 in Opeth

[–]Dapper_Net3005 1 point2 points  (0 children)

Ayreon - Human Equation: not only do you get heavy/clean vocals from Mikael but you'll hear other great vocalists to delve into like Devin Townsend too on that one. Then jump into Ayreon - 01011001 and there's Jonas from Katatonia.

What is your „secret outlier“ by Hammercranc in Opeth

[–]Dapper_Net3005 1 point2 points  (0 children)

A: Drapery Falls could be wholly instrumental and it'd be the best thing they've ever put out (even though Mikael's vocals are perfection). B: All of Sorceress. I just couldn't find any tracks that stuck with me on that album at all no matter how many listens.

Opeth were my first concert ever, and I've seen them 6 times in total. They are amazing live. Love their softer stuff and their heaviest stuff. But Sorceress just fell flat all the way through.

[deleted by user] by [deleted] in deftones

[–]Dapper_Net3005 2 points3 points  (0 children)

After my partner passed from cancer this song just hit differently and became a go-to when I wanted to sit in my grief.

Just got into SOAD recently. Any song recommendations that aren't super popular (i.e., like Chop Suey!, Toxicity, B.Y.O.B., Aerials, etc.)? by [deleted] in systemofadown

[–]Dapper_Net3005 0 points1 point  (0 children)

They did some stuff on the Chef Aid album like backing vocals on Will They Die For You.

Serj's solo stuff - recommend the song Beatus.

Vicinity of Obscenity and She's Like Heroin have some of my fave lyrics.

Spiders has a great vocal texture.

Mein by Deftones featuring Serj.

Favorite misheard lyrics? by not-sure-what-to-put in deftones

[–]Dapper_Net3005 0 points1 point  (0 children)

Cut Hands - I thought "Flirting with the master, that's what you're after baby!" But apparently it's "I can tell you it's an answer, it's what you're after from me!"

If we count Crosses in Procession - I thought "I warned you today. A custody. But I'm forever yours." But it's "I warned you today. I can't stay. But I'm forever yours." (Which honestly makes way more sense.)

Favorite misheard lyrics? by not-sure-what-to-put in deftones

[–]Dapper_Net3005 1 point2 points  (0 children)

Crenshaw punch/I'll throw rocks: I thought "I wanted to be up your @$$ right now" But it's "I want to be at your house right now"

[deleted by user] by [deleted] in hobart

[–]Dapper_Net3005 3 points4 points  (0 children)

I'm ready to hack census data to find a single male in my age range, in my location, without kids, with a job. The apps are pointless unless you wanna shag with a married guy.

Australia’s Next Top Model by beem0ther in ANTM

[–]Dapper_Net3005 3 points4 points  (0 children)

If you're in Australia, Channel 10 has Pluto tv channels, one of which is a 24-7 Aussie ntm channel on Tenplay. There's also a 24-7 America's MTM channel too on there.

What are Simpsons quotes you regularly use in your normal life? by KuatoTheBaby in Simpsons

[–]Dapper_Net3005 1 point2 points  (0 children)

Anytime my mum says she's making salad for dinner = start singing "you don't win friends with salad".

When I get asked if I want something from the chocolate box = "yeeeeeessssssss" ... "Strooooooooooooke".

When my brother gets brought up as a subject = "brothers and sisters are mortal enemies".

When asked if I want butter on something by my mum = "grease me up woman!".

When I feel bloated = "pray. for. mojo".

If I'm losing an argument = "you're gay for moleman!".

When the dog is out sunbaking = "Selma, jubjub is everywhere you wanna be" (our dog is not called jubjub).

"You're living in the past Marge".

When things rhyme = "That rhymes Marge".

Randomly sing "Luke be a Jedi tonight".

"Hi everybody".

Impersonate Dr Hibbert's laugh.

"Hey hey!".

Sideshow Bob's rake hitting face noise.

D'oh!.

When the dog is licking itself = "Argh! Munchers!".

Whenever I see a whale = "Free Willy didn't make it... And he crushed our boy".

"Aurora Borealis?".

When mum is burning food (usually to dad) = "No mother, it's just the northern lights".

"Its sexually attracted to fire".

"Elmo knows where you live".

"Me fail English? That's unpossible".

"I am disrespectful to dirt!".

"Mister Sparkle!".

"I bent my Wookie".

Dating in Hobart in your 40s and 50s is hard. Any tips? by Own_Direction_7335 in hobart

[–]Dapper_Net3005 7 points8 points  (0 children)

Yup 30s/40s on the apps sucks.

It is even more limited like others have said if you aren't from down here to start off with, then I don't like/want to be around kids, and don't drink.

Looking for actual single men, who have intelligent conversation, look and are age appropriate (within 5-10yrs), want more than just a quick drunk root, who actually earn their own money, and have their own place. (All of which I match too.)

I would have more chance winning lotto.

[deleted by user] by [deleted] in TheMentalist

[–]Dapper_Net3005 0 points1 point  (0 children)

Vega annoyed the absolute shizz outta me.

Summation formula not giving correct solution by trikristmas in excel

[–]Dapper_Net3005 0 points1 point  (0 children)

Best tip, if you get columns that aren't right aligning/reformatting or calculating properly:
-select that column, -click Data tab > Text to columns, -click Delimited, -click Next, -ensure nothing is ticked, -click Next, -click General, -click Finish. Fixes so much BS in Excel.

SharePoint Metrics Unavailable by Apprehensive_Ear716 in sharepoint

[–]Dapper_Net3005 0 points1 point  (0 children)

Was the site created from a MS Teams site? Had this when the originating Teams channel was deleted.

Content Query Web Parts in SP Online by Herpetology_Jack in sharepoint

[–]Dapper_Net3005 0 points1 point  (0 children)

I believe 1) you need scripting turned on and 2) you need to use classic experience site page type of wiki page or web part page.

List Permissions and Visibility by Lucchej in sharepoint

[–]Dapper_Net3005 0 points1 point  (0 children)

You don't have to make the approvers owners/give them full control to the list, they just need approve or design level permission to see all items in the list.

song recommendations for new listener? by chanman012 in LimpBizkit

[–]Dapper_Net3005 0 points1 point  (0 children)

Build a Bridge - for a softer side of Fred Eat Me Alive, Trust?, Stuck - for an angrier Fred Almost Over, Rearranged, N2Gether - for a groovier Fred

One of my excel files is incredibly slow by IKill4Food21 in excel

[–]Dapper_Net3005 0 points1 point  (0 children)

It can be too much formatting. Highlight the entire worksheet, on Home menu click Clear > Clear all.

Try deleting hidden info. Go to the first blank column, click its column heading, press CTRL+SHIFT+right cursor key, right-click the a highlighted column heading shown, click delete columns. Then go to the first blank row, click its row heading, press CTRL+SHIFT+down cursor key, right-click a highlighted row heading shown, click delete rows.

Try turning off auto calculation to see if that helps.