I’ve done a search in this forum and on the Goog and I can’t seem to find an answer to the issue I am experiencing. I’m hoping someone can help…
I have created an app with quite a few formulas in the Google Sheet and the calculations are working perfectly. What is happening though is the answers to the calculations are not in the correct format (as per the Google sheet).
The form input asks for a time duration ie HH:MM:SS
The input lands in the TIME GOAL column. From there, in the sheet, the duration is divided by 42.2 and the answer should then be 04:37 but instead, it is showing as a decimal, which in turn messes up the rest of the calculations. See image:
When I go into Google Sheets and update the formatting for that column back to duration, it fixes it in the glide sheet and everything works the way it should. See below after it has been changed in sheets:
Is there a way to ensure that the formatting of the Google Sheet cells are maintained when a new submission is made from a form within Glide?
I’ve also noticed that the Google sheet is not being updated with the submissions from the from. There are 9 rows in the Glide sheet, but there is only the first one on the Google Sheet (I added this one manually in the sheet while building it). See below:
(I have read on a previous post that this may have something to do with using arrays in the formula in sheets.
I’m new to Glide and I’m super excited by the possibilities and would love it if I could make this work. Any suggestions or help would be massively appreciated.