Formula for today's date

Carol Lashman

How can I include today's date in a report or sight?

Brett Evans

put   "=Today()" in a cell and pull the cell in to the report.

Carol Lashman

Hmmm... Tried this.  But all I see is the text of the function, not the value of today's date.  Do I need to format the cell somehow?

Carol Lashman

Got it.  I did need to set the column to a date format.  Thanks.

Torsten Reuter

Concerning this sight-sheet relationship: what triggers the today() function in a sheet cell to update the cell content?

If I reference from a sight to such a cell (containing =today()), the sight is receiving the "old" date. The only way to update the date is by saving the source sheet again.

 

Any ideas?

 

J. Craig Williams

Torsten,

 

See this excellent post by Rob Hagan:

 

https://community.smartsheet.com/discussion/how-force-sheet-fully-recalculate-api

 

It addresses your question.

(summary: the sheet needs to be 'touched' to update)

 

Craig