Results 1 to 5 of 5

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

Threaded View

  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.

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