Good day! Thanks for the video it is very informative. How do you get the script (specifically the one that retrieves a cell value) to place the answer in a given cell? In other words, I want to retrieve the cell value - one that will not change when the source cell changes - and put that value into a specific cell. I'm hoping the getValue will work for that, but I don't know how to tell the script to drop the answer in a particular place. Thanks very much!
Thanks a lot for this excellent video Amarindaz! One more question I would appreciate your help with. How can I get a specific sheet and a cell value from another spreadsheet file that is not active (opened) ?
Good job sir
Good day! Thanks for the video it is very informative. How do you get the script (specifically the one that retrieves a cell value) to place the answer in a given cell? In other words, I want to retrieve the cell value - one that will not change when the source cell changes - and put that value into a specific cell. I'm hoping the getValue will work for that, but I don't know how to tell the script to drop the answer in a particular place. Thanks very much!
Thanks a lot for this excellent video Amarindaz! One more question I would appreciate your help with. How can I get a specific sheet and a cell value from another spreadsheet file that is not active (opened) ?
How to find, search and highlight the cell using a search box and app script and button in google sheet