I'm trying to give a formula using the equal sign, when submitting a Short answer in a Google Form. If I'm writing
into the form and then submit it, I get the string
in the Google Sheet Response sheet. It does not seem to calculate this function automatically.
When trying to
getValue() this cell, I cannot find the quote, and so I cannot execute this function.
Does anyone have any good idea to solve this problem? Is it possible to execute this function in the Response sheet?