How can I include today's date in a report or sight?
put "=Today()" in a cell and pull the cell in to the report.
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?
Got it. I did need to set the column to a date format. Thanks.
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?
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
