I have a value in one of my cells that I would like to access, parse, and output a derive value in another cell. To do what I want in google sheet functions would be very tedious.
Is there to write and call an App script function in the cell? I'm new to App Scripts, but I thought this might be possible.
yes. you're talking about writing a "custom function"
so you'd write a function in the script editor like this:
myCustomFunction(value){
[your appscript code]
return newValue
}
Then you place this in a cell:
=myCustomFunction(B2)
or some other reference to a cell, and it should return the result of your appscript manipulations.