Is there a way where we can like grab a variable value set in a cell and use said value for the Row count in order to make a dynamic selection? Say the value in the cell its equal to the last row in use in another sheet, which in this case, is 5, so the range could be sort of like "getRange(DynamicRow, 2)" and that would select say, "B5"?
Excellent. Can you take this to one step further and make example of nested array?!. I mean push a child array inside main or parent array. Such complex concept is what we really need. Thank you much 🙏
For example if I have a value inside E4 (=5) and I want to add to this value another value e.g. 5, how can I do that with set.value? Means afterwards 10 should appear. And more important how can I do these for several rows, e.g. from E4 to E50 together? Thank you in advance
Can you please help me make a google script onedit for old value, every time the column cell is edited will get the value of change cell. For example column A is price and column B is date. Everytime the price will change it well get the old value of the price and get the old value of date, and set the oldvalue to the other C previous price column D previous Date. Thank you in advance hope you can help me.
Is there a way where we can like grab a variable value set in a cell and use said value for the Row count in order to make a dynamic selection?
Say the value in the cell its equal to the last row in use in another sheet, which in this case, is 5, so the range could be sort of like "getRange(DynamicRow, 2)" and that would select say, "B5"?
Excellent. Can you take this to one step further and make example of nested array?!. I mean push a child array inside main or parent array.
Such complex concept is what we really need.
Thank you much 🙏
Sure will create one
@@Amarindaz Higly appreciated.
👍 super
For example if I have a value inside E4 (=5) and I want to add to this value another value e.g. 5, how can I do that with set.value? Means afterwards 10 should appear. And more important how can I do these for several rows, e.g. from E4 to E50 together? Thank you in advance
Can u write a script to automatically generate named ranges within selection with column headers as names for each range.
Can you please help me make a google script onedit for old value, every time the column cell is edited will get the value of change cell. For example column A is price and column B is date. Everytime the price will change it well get the old value of the price and get the old value of date, and set the oldvalue to the other C previous price column D previous Date. Thank you in advance hope you can help me.
I have upload a image using apps scrip, once upload success I need to save that image name and id in google sheet. Kindly help on this urgently.