# Dynamic cell value not working **URL:** \ **Category:** Ask for Help\ **Created:** [February 9, 2020, 4:41pm UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426 "2020-02-09T16:41:40Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![anandp29](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anandp29/32/3376_2.png) [@anandp29](https://community.glideapps.com/u/anandp29)\ **Post date:** [February 9, 2020, 4:41pm UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/1 "2020-02-09T16:41:40Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 9, 2020, 4:54pm UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/2 "2020-02-09T16:54:36Z")
> [@Doesn't write on my Google Sheet](https://community.glideapps.com/t/doesnt-write-on-my-google-sheet/3968/2): > > 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. ---
**Author:** ![anandp29](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anandp29/32/3376_2.png) [@anandp29](https://community.glideapps.com/u/anandp29)\ **Post date:** [February 19, 2020, 1:46am UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/3 "2020-02-19T01:46:19Z")
Thanks. I need to look into arrayformulas as I have not used that before. Any good resources or links to learn? ---
**Author:** ![anandp29](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anandp29/32/3376_2.png) [@anandp29](https://community.glideapps.com/u/anandp29)\ **Post date:** [February 19, 2020, 2:44am UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/4 "2020-02-19T02:44:47Z")
Actually, did some Googling and I think I figured it out. I appreciate the info! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 19, 2020, 3:12am UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/5 "2020-02-19T03:12:55Z")
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. ---
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [February 11, 2022, 9:42am UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/6 "2022-02-11T09:42:22Z")
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 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2022, 10:12am UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/7 "2022-02-11T10:12:40Z")
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](https://docs.glideapps.com/all/topics/values/special-values). ---
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [February 11, 2022, 11:03am UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/8 "2022-02-11T11:03:12Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2022, 11:15am UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/9 "2022-02-11T11:15:42Z")
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? ---
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [February 17, 2022, 2:01pm UTC](https://community.glideapps.com/t/dynamic-cell-value-not-working/4426/10 "2022-02-17T14:01:21Z")
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