#1
|
|||
|
|||
MS project countdown #error
Dear all,
I created in field text1 the countdown formula: DateDiff("d",Date(),[Finish]) and this works well. I have certain rows not indicating a Finish date and then resulting in Text1 as an #ERROR. I tried to implement an IF function, but below ones are already dissaproved in the formula input field. Anyone an idea how to hide an #ERROR? IIF([FINISH] = , , DateDiff("d",Date()) IIF([Text1] = #ERROR , , DateDiff("d",Date()) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
A grave error in the Project Forum | Mattias | Chitchat | 0 | 02-01-2017 12:40 PM |
Error occurred, when I went to open a MS Project schedule. | HermannBaumgartner | Project | 1 | 10-29-2014 10:58 AM |
Formula To Calculate Countdown Days To Project Completion | Catherine | Project | 1 | 02-19-2014 11:15 AM |
Login Error in MS Project 2007 | awairkar | Project | 0 | 02-28-2011 02:39 AM |
Error 9571 when opening Project Server from Project Pro | mona | Project | 0 | 04-24-2007 07:50 AM |