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 submit a new row of data via the Glide app, it inserts the new data at row 101, completely ignoring the formula in column F (this is because the app sees the formula and assumes that the row is already taken). Any suggestions on how to better emulate this use case.

[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 delete any empty rows. Then everything will work.

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	4	1890	January 25, 2020
Rows in google spreadsheet not increasing Ask for Help	12	347	September 26, 2021
Add new row is clearing my Google Sheet formula Ask for Help	5	833	September 3, 2021
User input data goes in row 455 rather than next empty row Feature Requests	5	965	September 12, 2020
Sheet formula is not working on newly created row Ask for Help	24	3595	May 31, 2020

Dynamic cell value not working

Related topics