Gsheet Formula Glide Magic...with a leaky cauldron...🤓

[Jeff_Hager]

@resepsionis_ganteng

data from glide is entered in row 1001.
I want to run the formula automatically without manually deleting empty rows.

If data is adding on row 1001, that means you didn’t delete the empty rows. You only have to do it once. Glide will add new rows and the formula will populate on those new rows.

Arrayformulas used to be the only way to do any kind on computation logic with glide, so I know it works, but that was more than 2 years ago and a lot has changed since then. As @Darren_Murphy said, doing it in glide is much better and faster, but if you absolutely need it to be in the google sheet then using arrayformulas and deleting empty rows is the proper way to do it.

Regardless if you use glide computed columns or arrayformulas in the google sheet, I would recommend using one of those methods instead of manually populating a set number of rows with a formula, or trying to set a formula by setting a column value in glide. It’s just going to be too much extra work and probably not reliable or scalable in the long term.

Also keep in mind that there is an Excel Formula plugin and JavaScript plugin that may work for you and keep the logic in glide.

[antoniedik]

@Jeff_Hager

If data is adding on row 1001, that means you didn’t delete the empty rows. You only have to do it once. Glide will add new rows and the formula will populate on those new rows.

Arrayformulas used to be the only way to do any kind on computation logic with glide, so I know it works, but that was more than 2 years ago and a lot has changed since then. As @Darren_Murphy said, doing it in glide is much better and faster, but if you absolutely need it to be in the google sheet then using arrayformulas and deleting empty rows is the proper way to do it.

Regardless if you use glide computed columns or arrayformulas in the google sheet, I would recommend using one of those methods instead of manually populating a set number of rows with a formula, or trying to set a formula by setting a column value in glide. It’s just going to be too much extra work and probably not reliable or scalable in the long term.

Also keep in mind that there is an Excel Formula plugin and JavaScript plugin that may work for you and keep the logic in glide.

if there is a way to calculate the time duration of 2 dates using Glide or Hyperformula or Excel can you show me how?
I have also tried using Hyperformula on Glide but the results are less accurate than the Google Sheet formula.

[Darren_Murphy]

@antoniedik

if there is a way to calculate the time duration of 2 dates using Glide or Hyperformula or Excel can you show me how?

Just use a Math column with the formula End Date - Start Date.
This will give you a duration in hh:mm:ss format.
If you need it in a different format, that’s also possible.

[antoniedik]

if using end date - start date only shows the total hours.
whereas I want to bring up Days, Hours, Minutes and Seconds.

this is the difference result from 2 different ways.

correct.
I mean glide math not glide table.

[Darren_Murphy]

I would probably use Math columns to calculate the days, hours, minutes and seconds separately, and then stitch them together using a template column. Or maybe a single JavaScript column. Basically anything to avoid a sheet formula. But that’s just my personal preference. If your GSheet formula gives the result you need, and you’re okay with the sync delay, then there is probably no reason to change.