If I have a large spreadsheet that needs an update from many stakeholders, is there a way to: 1) give access to people to update their rows only 2) track the changes.

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

Alternatively, if there’s a MS Form (or SharePoint form, not as familiar) that could also do this, would want the stakeholder to be able to see their items, previous entry, and submit. Also be able to see changes for approval (maybe multiple)

Use Google sheets

Right. But can you give only certain permission for certain rows?
Or use a filter so they can only edit what they’re in charge of?
Without having them able to edit someone else’s?

Related Posts

Good outdoor date ideas?

Is there an app to target specific houses or streets for when they go on market?

There are certain houses located along certain portions of some roads that I don't drive by regularly. But I would love to know if any of them ever go on the market.

I was thinking it would be great to have a Google maps like app that you could browse and select a bunch of houses and eventually get a notification if any of them ever go on the market.

Or, is there any other low effort way of doing this?

like

2nd year associate here been with bcg for about 2 years (one promo under my belt), got an offer from a high growth tech startup thinking about exit right after bonus hits. salary about the same, job is interesting, better wlb, however (significantly) slower career trajectory. Tbh my experience at bcg has been mixed I learned a lot but not particularly enjoying the job (my feedbacks are on target, no issues there)
am I making a mistake here? is it worth waiting an other year before exit?

like

Can anyone at Pwc AC bangalore office confirm if they are reopening anytime soon or already working in hybrid mode? I have an offer from HR who insists that office isn't gonna open anytime soon but not ready to give anything in writing. Given that HR has miscommunicated multiple things (verbally), it is difficult to take them up on their word. I wanted to understand how long before they start calling people back to office.

like

Does anyone else take a day off from stimulants to try to resist building up a tolerance? I have had one psychiatrist recommend doing this, and another recommend NOT doing this.

like

Is it normal for a firm to load you up on tasks during your notice period? I have a metric shit ton of things to “take care of” before I depart and pretty sure I won’t be able to finish before my end date.

like

Has anyone worked for/with Evolent Health?

like

What should I expect at EY, just hired for Technology Consultant- CyberSecurity. College hire. Charlotte, NC

like

Is it wise to go to my company’s competitor for a promotion and risk burning a bridge?

For context, my small company was suddenly bought out by a large corp. I was about to get promoted to leadership but the new company doesn’t want to honor the title/salary increase we worked out. We only have one significant competitor in our industry, and it’s likely my best option. Love my company, been with them for years, but I’m really struggling with how frustrating this situation is.

like

What has your salary looked like as your career progressed? Starting, 3 years, 5, years, etc?

like

Eugene Mirman is very funny.

(15) Eugene Mirman | LinkedIn

Post Photo
likefunny

Deciding between Bangkok, Philippines and Bali for family trip ( extended family so 15-17 people). Which country would you recommend for may-June 2020? Not sure which country has better Airbnb either

Hello! I just came across an Art Director position with ServiceNow that I think I’d be a great fit for. Is there anyone willing to provide a referral for this position? I’m willing to answer any questions and provide any information!

I’m an over-apologizer. I say “sorry!” after so many things that really have no need to be sorry about. I remember seeing different things to say instead of this. Any examples y’all use?

likefunny

𝐒𝐮𝐜𝐜𝐞𝐬𝐬𝐅𝐚𝐜𝐭𝐨𝐫𝐬 𝐋𝐌𝐒 𝐀𝐝𝐦𝐢𝐧𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐇𝐞𝐥𝐩!

Scan to Download!! Save & Share the Card ..

#SAP #SuccessFactors #HXM #LMS #QRCards

Post Photo

I am looking for a senior role in financial services operational risk, controls management, preferably remote, but am open to travel for 20% to on-site or at hq. Any viable leads?

like

What is it really like for tax professionals who leave public accounting for “industry”/an internal tax department? Curious on pay diff, stress level, flexibility,etc in a general.

like

Chicago folks. What part of Glenview has an Indian community. Looking for a place to buy a house in Glenview/northbrook with good indian community.

like

Need 11 likes to start DM

like

Additional Posts in Excel Genius

Excel 🐠, need your help: how can I have gridlines removes as default? Not for a current workbook, but for all workbooks opened.

Y'all have or seen any good/short tab names for time based assumptions? (ie. the scenario manager tab with price decks)
"Time Based Assumptions" is long and can't think of a good way to shorten or reword.

like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

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

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

What can I use instead of vlookup when there is more than 1 value in the data?

like

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

This may be a tough ask...but does anyone know a way to to take tabular time-phased data and convert it to columnar without using power query / alteryx / tableau?

like

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

like

Experience a lot of downtime because I deal with massive amounts of data and need to constantly filter and delete records that are not relevant. Is there a workaround for this?

like

Question. I have data in Column A & I want to color highlight cells with data on Columns B-Z that don’t match A in the same row. How could I write formula/function that can do this?

like

Does anyone know if there is an excel plug-in that links brokerage data (i.e. account info from fidelity/Schwab, etc.) so I can track/analyze on excel?

likefunny

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

I’m trying to extract numbers from a string. I googled a formula, however the formula rounds up the last two digits of a 16 character string. Is there are a formula I could use eithoutcharacter limit?

Am I missing anything? (Yes, I know there are 100,000 401k calculators online)

Post Photo

Opinions wanted: I inherited an excel file around 2k rows and 50 columns used to manage stakeholder communications. Mostly free text fields and it feels very chaotic. It will be easy to miss an update/ hard to get a summary of changes without reading most of the columns. Would it be worth converting to an Access Db just for my use? Willing to put in the time to figure it out, but not sure if it will be more/less difficult to manage over time

like

what’s the quickest way to find all offsetting entries in a huge data sheet?

like

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

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