Are sharepoint calculation formulas the same as excel? I want to pull the last 2-3 digits from the column and put it into the immediate column on the right. What can I use?

Posting as :
works at
You are currently posting as works at

Related Posts

Currently going to school for my cannabis certification but I rarely see any jobs that offer cannabis research. I currently work in a lab/greenhouse environment and would love to continue that line of work with hemp/cannabis. Yet again no luck whatsoever, just finding jobs as budtenders or running a dispensary. Does anyone know where I can find research-based cannabis jobs? I have a degree in horticulture with lab experience.

like

Is PEPI doing 2 years of assured bonuses (for new hires, given the timeline) at the manager and Director levels these days? Heard the firm might be increasing bases as well!

like

I had HR round discussion on last Saturday with Mphasis, they told me that they will release offer letter on Monday or Tuesday but today is Friday I didn't receive offer letter yet, only received selection mail from talent team on Wednesday.

My joining date in other organization is 13-sept.

Should I wait for offer letter or start joining formalities with other organization?

like

I want to quit so f’ing bad

likeupliftingfunny

Please help me to apply for a job at Google.

like

Making an offer. The sellers said they had 30+ people walk through the open house today, and are asking for best and final. They’ll make a decision on Monday. The list price is 775k. We were originally thinking of offering 700 to start since comps are around 735k. However, this is nicer than the comps renovation-wise. What would you all suggest we offer? We’d rather lose the house than overpay, so this concerns us.

like

There are so many great questions in this bowl but little were answered. If someone can graciously go over them it would be great, thank you!

like

Hey guys - does anyone have recommendations for Indian wavy 5x5 or 6x6 closures? I was going to order off of Amora Renae (https://www.amorarenaecollection.co/product/thin-swiss-lace-5x5-closure/) but they aren’t restocking. I’m still getting bundles from them, but clueless on another solid company that would have matching hair (friend is making me a wig bc of a natural hair crisis I’m having, I’m absolutely clueless when it comes to anything like this)!

like

And yet people still pretend this isn't a concern

Post Photo
like

How long is too long to wait for a raise? I've been waiting seven years and have had 2 title (and responsibility) promotions since the last raise. My manager says I deserve it and am long overdue. The CEO says we "can't afford it" and that "there are things that matter more than money." That's easy for someone not living paycheck to paycheck (during an inflation crisis) to say. I don't know what to do. How long is normal to wait? Especially with an employee's market like this?

like

Hi All,

I am selected in cognizant at 15 LPA , as senior associate. Tech Stack :- Mainframe , Python.
YOE :- 5.8.
Q1. What are the roles and responsibilities of senior associate?

Q2. As per the interview I have been selected for center of excellence. Can anyone please help me regarding the work how it is ?

like

Who here has slept with a partner on their project? How did it end? Did it negatively or positively affect you/your career?

like

In your opinion, where is the safest (but still exciting) place for a female living alone in Manhattan?

like

Hi fishes🐟🐠🐟
Urgent opening at Cognizant 👨‍💻👨‍💻PAN india

Azure data factory (4-12 yoe)
Azure databricks (4-12 yoe)
Dm for referrals....

like

Junior Dev presents an issue they’re having. I hint to the fact that it may be framework related (this is a very simple fix). The questions they are asking seem out of context, so I ask if they have done any framework related research generally, as our entire application is built on top of this. They answered no, they have been here for months, and it’s not like this wasn’t in the job description. Am I missing something here? Trying to be helpful but stuff like this is frustrating.

like

Looking for remote work or contracted work. Small solo firm in Missouri wondering how to find collections work or remote document review to supplement income. Anyone know of any companies that need attorneys on 1099 basis?

like

Dear All,
I'm looking for job opportunity as system administrator. I'm any opportunity please let me know. Thankyou
YOE: 6.5

like

It’ll be okay.

Post Photo
likefunny

Hey fishes, how it works like working for MNCs like Microsoft /adobe but the payroll will be with different company! Is it okay to accept such offer ???

like

I work remotely for a series A start up, TC is about $115K + equity. I work approximately 30hrs a week in a busy week, only meet with my boss and team once a week. I just got an offer for $140K + 4X the amount of equity I currently have… however, not sure it’s worth letting go of the incredible freedom and work life balance I currently have. Any thoughts to help make the decision?
PS: I love our product, but not as passionate about the other startup

like

Additional Posts in Excel Genius

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

Hey, tips for where to look for good excel cheat sheets online? :)

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Does anyone know how I can conditionally format a table with a sliding scale? I have a value that is supposed to fit in a range. I need the first possible range the number can fit in to be formatted. Thanks

likehelpful

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
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

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal