cell reference on dashboard


I have a dashboard that references a cell in a sheet. That cell contains a formula that displays a value based on date triggers (future, open, past due). My problem is the cell value will only update if I open the sheet and then click save. Is there a way to do this so I don't have to open the sheet everyday? Its a background sheet that is setup once when a new contract is signed.

Best Answer