Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Aging Items Based on TODAY
Hi,
I'm trying to use the TODAY function to work out the age of an item. In Excel I would have a cell with =TODAY(), and do a calculation to subtract the date of the item from this. I have tried using =TODAY(), =TODAY, TODAY, TODAY(), but can't get it to bring back today's date (got #INVALID COLUMN VALUE, #UNPARSEABLE or just the text. Does anyone know how I can use this function?
Thanks in advance,
Alanna 
Comments
-
Edit column properties by clicking on the top cell and make sure the column format is 'Date'
=TODAY() will do
Is it addressing your issue?
Cheers
-
Charles is correct, if your column containing your formula AND the column containing the date you are checking against is not a date column then your formula will not work correctly.
-
Thanks very much, it's working now
