Microsoft Office Forums MS project countdown #error

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2019, 09:43 AM
Matthijs2005 Matthijs2005 is offline MS project countdown #error Windows 10 MS project countdown #error Office 2013
Novice
MS project countdown #error
 
Join Date: Apr 2019
Posts: 1
Matthijs2005 is on a distinguished road
Default 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())
Reply With Quote
Reply

Thread Tools
Display Modes


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
MS project countdown #error Error occurred, when I went to open a MS Project schedule. HermannBaumgartner Project 1 10-29-2014 10:58 AM
MS project countdown #error 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


All times are GMT -7. The time now is 09:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft