#1
|
|||
|
|||
Now() Function Not Updating in MS Project
Hello,
I am new to working with MS Project, so please bear with me I am trying to create a column that will give the days from now until the end of the task. So, essentially number of days from today to task finish date. I inserted a new column and added the following formula: DateDiff("d",NOW(),[Finish]) This seems to work, however, when I open the document the next day, the column doesn't automatically update. So I have to right click on the column, select custom fields, and select the formula button. I don't have to re-enter the formula, at this point, I just have to click OK and it will update. I was hoping that this would work like the Today() function in excel and update each time that the document is opened. Any tips that anyone is able to share would be greatly appreciated! |
#2
|
|||
|
|||
that seems odd. Could you use [status date] instead which would give you control of that date which is used...
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Project task numbering changed after linking item in subproject to m aster project | rrs_2017 | Project | 0 | 09-06-2017 06:07 AM |
Microsoft Project Server, Microsoft Project Online and Project Web App - Whats the difference? | chocolateCupcakes | Project | 1 | 02-11-2017 12:25 PM |
Restrict Editing function disable insert textbox function | IanM_01 | Word | 5 | 11-21-2015 02:29 AM |
#REF! Error in calling VBA function disappears when function is copied | lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |