+ Reply to Thread
Results 1 to 5 of 5

Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    colorado
    MS-Off Ver
    excel 2007
    Posts
    11

    Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets

    I have sample spreadsheets which would make this very easy for you to solve but Excel Forum won't let me post any links yet.

    I need help with ONE FORMULA or ONE SMALL SIMPLE SCRIPT in Google Sheets to solve this spreadsheet problem.

    I have a master spreadsheet with all my formulas in a row.

    I want to have many slave spreadsheets pulling the formulas in via IMPORTRANGE.

    So if I need to change a formula I can change it only in the master and it will propagate.

    Problem is IMPORTRANGE only imports values. not formulas.

    I can import the formulas as text strings without the equal sign from the master to the slave. So now I have a row of all the text of the formulas, but I can't seem to reference those cells to then build the formulas and have Google Sheets recognize them as formulas instead of text strings.

    I tried to combine equal sign and the cell with the formula text:

    ="="&[cell reference with formula as text only without an equal sign]

    the result is the correct text:

    =[my formula]

    but Google Sheets does not recognize it AS a formula. It is just showing it as text!

    How can I have a master sheet of formulas to be used in many slave sheets through importrange? Can I do it without a script?

    And, can a moderator allow me to post some links to my Google Sheets so people can help me? It's very important for me to solve this ASAP for work.

    I read on a forum that:

    "It's possible to do this with Google Apps Script. Use the getFormula / setFormula for single formulas and getFormulas / setFormulas for formulas in a range."
    Last edited by excelroofing; 08-21-2018 at 09:08 PM.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave She

    Cross-posted at: https://www.mrexcel.com/forum/excel-...ve-sheets.html

    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    10-02-2012
    Location
    colorado
    MS-Off Ver
    excel 2007
    Posts
    11

    Re: Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave She

    Thank you sorry for not providing a link. Now I know.

  4. #4
    Registered User
    Join Date
    10-02-2012
    Location
    colorado
    MS-Off Ver
    excel 2007
    Posts
    11

    Re: Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave She

    The rules say to post a link to your other posts, but I am not allowed to post links. What is the policy in that case?

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave She

    In that case, provide the link using a QUOTE tag (available on the posting menu) as a wrapper for the link.

+ 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. Hide formulas in Google sheets?
    By stockman in forum Excel General
    Replies: 1
    Last Post: 01-08-2018, 08:55 AM
  2. Replies: 0
    Last Post: 10-31-2017, 12:56 PM
  3. [SOLVED] Google sheets, auto email by script
    By Ditch1983 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 05-16-2017, 08:10 AM
  4. Filtered View With Formulas - GOOGLE SHEETS
    By Vilac7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2017, 12:09 AM
  5. Google Sheets Script not working
    By jsmity in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-02-2017, 11:36 AM
  6. google sheets button with script
    By tselek1985 in forum Excel General
    Replies: 1
    Last Post: 10-17-2016, 06:18 AM
  7. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM

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