+ Reply to Thread
Results 1 to 5 of 5

Use a master formula Google sheet that other sheets can connect to and use said formulas

  1. #1
    Registered User
    Join Date
    01-19-2023
    Location
    Wisconsin, US
    MS-Off Ver
    2021
    Posts
    4

    Use a master formula Google sheet that other sheets can connect to and use said formulas

    Hi,
    I have made a Google sheet at work that suggests a grade (A,B,C,D or F) depending on what dropdown values have been selected, this all is working fine.

    However, I am interested in knowing how I use a master Formula sheet that other sheets can connect to.

    The reason I wish to do this is that each employee (around 30) uses their own sheet that all looks the same but is tied to them. This means any change in code I make, I then have to replicate across 30 or so sheets which can get time consuming and laborious.

    So I would like to add my formulas to a master sheet that all the other sheets are connected to, thus allowing for a single update of the code on the master sheet and these changes are then done on the other 30 sheets.

    I have a simple formula here =if(D3="F", "Scrap","") that is on my master sheet but when I attempt to take that code onto the other sheets all I get is a string and do not recognize it as a formula.

    I hope this makes sense, I did do a search on this before posting this but I could not find anything, apologies if I missed it.

    Thanks
    Neil
    Last edited by 6StringJazzer; 01-21-2023 at 07:17 PM. Reason: Moved from Excel Formulas & Functions

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Use a master formula Google sheet that other sheets can connect to and use said formul

    Can you please use this linked file to create a sample of what you are trying to achieve:

    https://docs.google.com/spreadsheets...gid=2100307022
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Registered User
    Join Date
    01-19-2023
    Location
    Wisconsin, US
    MS-Off Ver
    2021
    Posts
    4

    Re: Use a master formula Google sheet that other sheets can connect to and use said formul

    Hello janmorris,
    I have done as you have asked, thanks for your reply

  4. #4
    Registered User
    Join Date
    01-19-2023
    Location
    Wisconsin, US
    MS-Off Ver
    2021
    Posts
    4

    Re: Use a master formula Google sheet that other sheets can connect to and use said formul

    I have tried to paste the updated forms URL but it will not let me as it says I need to post more posts before I can paste a link. However the above link works fine

  5. #5
    Registered User
    Join Date
    01-19-2023
    Location
    Wisconsin, US
    MS-Off Ver
    2021
    Posts
    4

    Re: Use a master formula Google sheet that other sheets can connect to and use said formul

    I believe I have managed to work out how to do this - thanks for looking

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  2. [SOLVED] Google Sheets: Update slave/child sheets from Master/Parent sheet
    By JGREEN17 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-29-2021, 03:03 PM
  3. Google Sheets Master Sheet that pulls in data from other sheets with the last edit date
    By Badvgood in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 12-19-2020, 12:04 PM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. Connect to Google Sheet to Power Pivot
    By Kehjz in forum Excel General
    Replies: 1
    Last Post: 04-30-2015, 04:27 AM
  6. [SOLVED] to insert a master sheet with formulas which can verify other work sheets in it
    By greatairi in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 11-20-2013, 12:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1