Cell link not updating consistently...?

Techspan CT

Hello All,

I am having trouble with getting a report to update consistently with cell links. This screenshot shows the cell history showing it only updated at 4.57pm today.

This is the formula in the cell "=SUM(COLLECT({$_Today}, {Todays_Date}, Date@row))" where $_Today is an external reference to a column with the value and Todays_Date is the same sheet with the date.

This is the external sheet that is getting referenced and as you can see the last row was added at 4.23pm yet the metrics sheet only updated at 4:57pm.

This is causing issues with my dashboard as i have a report that goes out at 4.45pm and it isn't getting the latest data. The day before (19th July) you can see it updated right at the same time at 3:51pm and again at 8:54pm.

What could be causing the delay?

Andrée Starå

Hi @Techspan CT

I hope you're well and safe!

This might help simplify your process and make it more secure.

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Techspan CT

Thanks @Andrée Starå ,

I am already using this feature and today's date is added using automation. The issue is that sometimes the cell links update immediately and sometimes there is 30-40min delay.