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.

Calculate days remaining

Michael Lang
edited 12/09/19 in Archived 2016 Posts

I have an estimated project Finish date of 8/9/16 in a column "Finish".  this date is in row 6 and row 161.  I have entered a row name TODAY and set the date to current date in the 'Finish" column row 4.


I attempted to use the formula:



I get no result or error message.  Just the formula.


What am I doing wrong?


I did a search on this site before submitting this message.



Date calculation issue.JPG


  • Joel Johnson



    When dependencies are enabled functions don't work in the durration column...See below.  I would suggest making a new column for calculations.


    I found a Q&A talking about this in the help articles:



    "Q. I typed my formula correctly but it's displaying as text in the cell. What went wrong?
    A. When dependencies are enabled on a sheet, formulas aren't allowed in the dependency-enabled columns: start date, duration, finish date, predecessors, % complete or % allocation. The values in these columns are generated automatically based on the dependency settings and would overwrite formulas. If a formula is manually typed into one of these columns, it will display as plain text rather than performing a calculation."


  • Stan Adell
    Stan Adell ✭✭
    edited 05/15/18

    I am stuck trying to calculate days remaining in a project (your article link doesn't work). I understand about columns with dependencies so I created a new Date Column. I used the Today() formula and the end date, but the result is #DATE EXPECTED error message. 



This discussion has been closed.