+ Reply to Thread
Results 1 to 6 of 6

Google Sheets Auto fill cell formula from different cell

  1. #1
    Registered User
    Join Date
    03-09-2022
    Location
    Canada
    MS-Off Ver
    google sheets
    Posts
    5

    Google Sheets Auto fill cell formula from different cell

    Hello,

    I am new to google sheets and I need some some help finding a function that auto insert text in a cell based from the content of a different cell while the function is hidden in another cell.

    I want the function to stay separated in another cell and write and write text in the second cell based on the first cell

    Just like this : If RED CELL contains "xyz" then "123" is written in the GREEN CELL

    Screenshot_49.png

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Türkiye
    MS-Off Ver
    2010 - 64 Bit on Win7
    Posts
    945

    Re: Google Sheets Auto fill cell formula from different cell

    A cell housing a formula can not assign a value in another cell. This can not be done in Google Sheets nor any other spreadsheet programs.

    You can do this only if you use a script....

    But a solution with a formula is explained in the picture below, if you prefer to use... Note that, cells F5 and G5 must be empty.
    Attached Images Attached Images
    Last edited by Haluk; 03-09-2022 at 05:17 PM.

  3. #3
    Registered User
    Join Date
    03-09-2022
    Location
    Canada
    MS-Off Ver
    google sheets
    Posts
    5

    Re: Google Sheets Auto fill cell formula from different cell

    Quote Originally Posted by Haluk View Post
    A cell housing a formula can not assign a value in another cell. This can not be done in Google Sheets nor any other spreadsheet programs.

    You can do this only if you use a script....

    But a solution with a formula is explained in the picture below, if you prefer to use...
    Thank you, should I use Apps script from this submenu ? If so, could you help me write a function to do that ?

    Screenshot_50.png
    Last edited by georgeausters11; 03-09-2022 at 05:25 PM.

  4. #4
    Registered User
    Join Date
    03-09-2022
    Location
    Canada
    MS-Off Ver
    google sheets
    Posts
    5

    Re: Google Sheets Auto fill cell formula from different cell

    Quote Originally Posted by Haluk View Post
    A cell housing a formula can not assign a value in another cell. This can not be done in Google Sheets nor any other spreadsheet programs.

    You can do this only if you use a script....

    But a solution with a formula is explained in the picture below, if you prefer to use... Note that, cells F5 and G5 must be empty.
    Now I saw you provided me that function, everything is good but I need to post the "123" to the left of function not right, basically the function should be on H5 and "123" in E5

  5. #5
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    797

    Re: Google Sheets Auto fill cell formula from different cell

    heres an Apps Script that writes into G7 if C7 contains "xyz" (and clears it if it is empty):

    Please Login or Register  to view this content.
    you need to save then run the script and give authorisation.
    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]

  6. #6
    Registered User
    Join Date
    03-09-2022
    Location
    Canada
    MS-Off Ver
    google sheets
    Posts
    5

    Re: Google Sheets Auto fill cell formula from different cell

    Thank you ! I'm gonna try it right now.

+ 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. Replies: 0
    Last Post: 10-31-2017, 12:56 PM
  2. Auto fill cell in different sheets, based on a check box.
    By ben83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2016, 04:09 PM
  3. [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
  4. 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
  5. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  6. Replies: 1
    Last Post: 12-19-2013, 07:50 PM
  7. Replies: 1
    Last Post: 09-07-2011, 05:57 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