I currently have my Google sheet set up so that column F will be automatically determined based on the input in column B (using a formula). If there is no input/data in column B, the value in column F for that row will just appear blank. I copied this formula for the first 100 rows, but when you sub…

[image] Doesn't write on my Google Sheet Scroll down to the bottom of the sheet. The record is there. You populated all of your rows with formulas. New records from Glide will not touch these existing rows. You need to switch your formulas to Arrayformulas and then de…

Thanks. I need to look into arrayformulas as I have not used that before. Any good resources or links to learn?

Actually, did some Googling and I think I figured it out. I appreciate the info!

Just make sure when using arrayformulas to delete all empty rows. Otherwise any new rows will still be added at the very bottom of the sheet.

Hi @anandp29 I’m curious of your formula for this. I’m a bit struggling here. I’d like to have today’s date entered for each new entry. It’d be to have an arrayformula for that column setting =Today() for each new entry row. Thanks

You don’t need sheet formulas for this. Just write the current datetime to the column as part of your Add Row action, using the Current Datetime Special Value .

Thanks @Darren_Murphy actually I need the actualised date (=Today()) and not a time stamp. But thanks for the suggestion. I use this also but to users when the info was last actualised.

To get that, you can use a Math column together with the Now special value. However, that would only be available in Glide, not in your Google Sheet. Do you actually need this value in the Google Sheet? What will you do with it? Is it something that is better done in Glide?

Hi @Darren_Murphy Sorry for the late feedback. I’ll keep my solution for the moment with the arrayformula+today as I need it on my GSheet. So all good on my side. Thanks for the support. Thibaud

Dynamic cell value not working

Ask for Help

Jeff_Hager February 9, 2020, 4:54pm 2

Topic		Replies	Views
Doesn't write on my Google Sheet Ask for Help	5	1862	February 4, 2024
Rows in google spreadsheet not increasing Ask for Help	12	301	September 26, 2021
Add new row is clearing my Google Sheet formula Ask for Help	5	811	September 3, 2021
User input data goes in row 455 rather than next empty row Feature Requests	5	945	September 12, 2020
Sheet formula is not working on newly created row Ask for Help	24	3510	May 31, 2020

Dynamic cell value not working

Related topics