(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
I'm trying to set up a flag or filter in Project to capture upcoming tasks that are not yet done.
This is the IIf statement I'm using for a custom field. Project accepts the syntax, but returns all fields as a 0. What am I doing wrong? The statement is meant to flag all tasks that are not done and a finish date within the next 7 days.
IIf(([% Complete]<100) AND ([Actual Finish]<ProjDateAdd([Current Date],"+7d")), 1, 0)
Printer-friendly version
Send to friend
Renzo,
The two expressions on either side of your AND operator are mutually exclusive - a task cannot be incomplete AND still have an actual finish date - so the condition always evaluates to FALSE. Why not use [Finish] instead of [Actual Finish]?
Good luck, tom
Email: PPadmin@planningplanet.com
Replies