Formula columns not updating automatically after data is pulled in via datamesh

anna_ashby

We discovered that our formula columns are not updating automatically after data is pulled in via datamesh and they only update if someone goes into the sheet, clicks into some cells, then saves the sheet. Support told me to set up an automation on the sheet that does something like locking then unlocking a specific cell to trigger a recalculation of the formulas, but after a few months of trying different methods, none of them seem to work. Has anyone else had this experience, and found a better workaround that doesn't involve me going into each of the 8 sheets every day to save them manually? Some background on the sheets in question- they have 2115 rows and 127 columns (60 of which are formula columns), and they have already been broken out into multiple sheets to try to reduce number of columns, so that's not an option.

Georgie

Hi @anna_ashby,

It sounds like your formulas might contain the TODAY Function. This function is only updated when certain actions are taken, such as opening the sheet and saving it - you can see a full list of the actions that update it within the help article I’ve linked.

However, there are several options for automatically updating the TODAY function, all of which can be found in this help article: Automatically update the TODAY function in formulas.

Hope that helps!

Georgie

anna_ashby

Thanks for your reply Georgie! I am going to try one of the automation setups from the article and see if that works.