Timeline for Use `setValue` to update a column based on values of two others that match their respective values in reference cells
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 12, 2019 at 20:14 | vote | accept | Sam Davies | ||
| Sep 9, 2019 at 21:26 | history | edited | Sam Davies | CC BY-SA 4.0 | edited title |
| Sep 9, 2019 at 5:26 | answer | added | Tedinoz | timeline score: 2 | |
| Sep 9, 2019 at 5:16 | comment | added | Tedinoz | FYI - refer Adding clause of and/or to if statement in google docs script. A good, short summary from @Sergeinsas and 'user34612' for the codes for && (and ) and || (or), as well as the conditional test of 'equal to' and 'not equal to'. | |
| Sep 9, 2019 at 2:32 | comment | added | Sam Davies | Thanks. 1) I have written some code, so far i'm able to change the values of a column to x using setValue but obviously it needs to meet the criteria of the reference cells first. 2) I was thinking of having it run by adding it to a custom menu. 3) Sorry I don't mean script I mean function. 4) The data will be growing so the amount of rows will change as it grows. I believe the link that you provided changes a value in a column based on a value in another column not based on a value in B2. Also another difference is there are two conditions to meet not one. | |
| Sep 8, 2019 at 0:20 | review | Close votes | |||
| Sep 24, 2019 at 3:05 | |||||
| Sep 8, 2019 at 0:03 | comment | added | Tedinoz | Possible duplicate of How do I update one column based on the value of another using a script? | |
| Sep 7, 2019 at 3:30 | comment | added | Tedinoz | Welcome. A few things: 1) Sounds like you have a clear understanding of the process. Have you had a go at writing any code (anything at all) to do this. 2) How often/when/what trigger will drive this script? 3) You've specifically asked for a script; what if the same thing can be done by a function? have you considered that alternative? 4) Your demo data is only 5 rows, how many rows of data in your live data? | |
| Sep 5, 2019 at 23:45 | history | edited | marikamitsos | CC BY-SA 4.0 | Minor improvements |
| Sep 5, 2019 at 23:35 | review | First posts | |||
| Sep 5, 2019 at 23:45 | |||||
| Sep 5, 2019 at 23:30 | history | asked | Sam Davies | CC BY-SA 4.0 |