Dashboard

Jeg618

I am trying to create a widget on Dashboard for project progression that includes factors such as "Total development cost to date" "Total development cost this calendar year" "Future spending in next 1,2,3, months". How do I program the cells in sheets to reflect these dates (ie. todays date plus 20 days for next months future spendings) but constantly updating with "today's" date so that when you look at Dashboard it'll always be updated to that day. 

Mike Wilday

In a nutshell, you'll want to create those metrics using Sumifs on the main sheet itself or by using Cross Sheet references. Then you can use the metric's tool to display the data you create. There are some bugs related using formulas and dates with today() that center around the fact that the TOday() date doesn't update unless you open the sheet each day. I would recommend building your data out on sheets that are accessed regularly. 

Paul Newcome

To further expand... 

 

The sheet doesn't have to be OPENED to update the TODAY function. It simply has to be activated. If a new form entry is made, and alert or action, cell linking, update request, etc. As long as the sheet is active, the TODAY function will update.

 

A workaround for this is to create a sheet that simply has 

 

=TODAY()

 

in a date column. You can then reference that cell in any formula across any sheet. Then you would only need to open that one sheet, and any other sheet referencing that cell should automatically update.