Hello, I noticed there is an inner problem with google sheets scripts when for example I have a cell that contains for example a number obtained from different sheets using long and complicated formulas. When trying to got that number by using these 2 cods:
a=get.range().getValue()
getrange.Setvalue(a)
what I will be getting is a "loading" message that will never change.
to tackle this issue, I separated the complicated formulas to 3 different cells and then used hard coded numbers. that was the only way I was able to get the data I wanted without a "loading" response
LinkedIn
Twitter
