+ Reply to Thread
Results 1 to 3 of 3

Google Sheets - Auto-populate cells with formula when adding new rows

  1. 08-28-2019, 06:26 PM #1
    shelleykl
    shelleykl is offline
    Registered User
    Join Date
    08-28-2019
    Location
    Visalia, Ca
    MS-Off Ver
    2010
    Posts
    3

    Google Sheets - Auto-populate cells with formula when adding new rows

    Hey all!

    So, I've got this lovely spreadsheet I've been trying to make to track certain data for a program. However, some really not computer savvy / excel savvy individuals are the ones actually using the spreadsheet and the biggest issue is the creation of new rows.

    I'd love it if we could just have the formula auto-fill whenever a new row is created. I know this is possible, however I'm just not sure how to nest it with the formula. The formula is:

    =IF(AND(NOT(ISBLANK(A2)),NOT(ISBLANK(B2)),A2<B2), 1, 0)

    Is there a way to make this work?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-28-2019, 08:31 PM #2
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Google Sheets - Auto-populate cells with formula when adding new rows

    Hello,

    If you are actually "inserting" new rows, the only way I know to add the formula to the inserted cells would be via a script (macro) or some google add-in.

    Otherwise, you can use this formula in all the rows that you intent to use, example from C2:C25
    Please Login or Register  to view this content.
    Formula in D2 would be slightly different
    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
    Reply With QuoteRegister To Reply
  3. 08-28-2019, 08:46 PM #3
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Google Sheets - Auto-populate cells with formula when adding new rows

    Try this

    in C2 and copy down

    =IF(NOT(AND(A2="",B2="")),IF(A2<B2,1,0),"")

    in D2

    =IF(NOT(AND(A2="",B2="")),IF(A2<B2,0,1),"")
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help with a formula to auto-populate age across sheets
    By reykjavik2009 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-02-2019, 07:18 PM
  2. [SOLVED] Auto Hide Rows in Google Sheets
    By FragaGeddon in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-11-2019, 02:16 PM
  3. [SOLVED] Auto Hide Rows in Google Sheets
    By FragaGeddon in forum Excel General
    Replies: 4
    Last Post: 03-11-2019, 01:53 PM
  4. How to get excel to auto populate an address from google?
    By newm2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2017, 03:37 PM
  5. [SOLVED] Auto Fill Formula into New Rows/Columns [Google Sheets]
    By banyanman in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 05-03-2016, 03:24 PM
  6. Can't Auto Populate Cells in One Sheet from Data Cells in Other Sheets with 3 Conditions
    By MZett in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-29-2014, 12:59 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1