How to auto update field value in a summary sheet?


I am using a formula to caculate the "Elapsed days" in the red circle of the Summary sheet as shown below , and display this value in a Dashboard.

The problem is that this value "Elapsed days" is not auto updated daily in the dashboard as i expected.

What I have done is refresh the sheet then save it. After this, the dashboard showed the correct value as i expected.

Can you help to make the update automatically?

Thanks in advance for any guidance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!