app inventor store formula in google sheets with quotation marks

would like to add function in google spreadsheet every time user submit.

When i choose to store the function with text the formula does not make the calculation it's just store like text because of the quotation marks.

any idea hoe to solve it?

--

From what you show, I cannot figure out what could be wrong. Show all relevant blocks, or post an as small as possible .aia that shows the problem.

-- 

I don't think, you can post a formula like that into the spreadsheet
you might be able to modify the Google Apps Script and add the formula there

https://www.puravidaapps.com/spreadsheet.php

spreadsheet.aia

--