I am sending this message since I need some help. I would like to have the right time in the App : Sales Stripe sheet. I tried to change the time zone in Stripe but I still have the same time. There is a gap of 1 hour between my time zone.
You don’t want to, and can’t for that matter, apply the formula into an existing column that’s already being filled by Glide. You will want to create a new column to perform the date math. I would also advise using an arrayformula, so you only need to apply the formula once on the first row, then delete all empty rows, so new rows aren’t added at the very bottom of the sheet.
Also, I know this is the case with the App:Logins sheet, so probably the same in the sales sheet, but the timestamp stored is in a string format instead of a date format, so you may need to convert it into a valid date before adding time to it.
I tried to formatting the column as datetime value and I was able to increase the time. Thanks !
Now I am looking an solution for not displaying the empty fields. if anyone can help please ? In attachment a screenshot.