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
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.
Last edited by Haluk; 03-09-2022 at 05:17 PM.
Thank you, should I use Apps script from this submenu ? If so, could you help me write a function to do that ?Originally Posted by Haluk
Screenshot_50.png
Last edited by georgeausters11; 03-09-2022 at 05:25 PM.
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
heres an Apps Script that writes into G7 if C7 contains "xyz" (and clears it if it is empty):
you need to save then run the script and give authorisation.
Please Login or Register to view this content.
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]
Thank you ! I'm gonna try it right now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks