Auto-refresh cells with formulas

[Reda El Khayat]

Hi 👋 

when setting few cells with data programatically, other columns using formulas pointing on the previous cells doesn't update their values - I need to move to another sheet page and go back to it to see the new formulas results.

Any advice on this please.

Best,

[Sangeetha Priya Murugan]

Hi Reda,

We have checked your reported issue by updating the cell value dynamically in a button click event (F31) and formula referred in the cell F32. And the formula refreshed properly after updating the cell value programmatically. Please find the sample link below.

Sample Link: https://stackblitz.com/edit/react-ivhzuj?file=index.js

So, before we proceed further, please share the details how you update data dynamically in spreadsheet cell or replicate your issue in the above sample with customization codes and send back to us. Based on that we will check and provide you a better solution quickly.

Regards,

Sangeetha M