Loading...
Quick Links

Reply To: Status date in a filter

Home Forums Discussion Status date in a filter Reply To: Status date in a filter

#409794
Oliver GildersleeveOliver Gildersleeve
Guest

Wonderful! Your guidance lead me to Google search for “Microsoft Project Status Date” in which I found Darren Deason’s July 3, 2014, “Working With [Status Date] Field in Microsoft Project Formulas.” It showed that [Status Date] can be used directly in a formula without using another field first. So, I put together the following in a Flag field to identify tasks needing updates, even those that had been split by “Move incomplete parts to the Status date.”

IIf([Actual Start]=projdatevalue(“NA”),IIf([Start]<[Status Date],Yes,No),No)
Or IIf([Actual Start]<>projdatevalue(“NA”),IIf([Resume]<[Status Date],Yes,No))

The first IIF identifies unstartled tasks with a planned Start date before the Status Date.
The second IIF identifies actually started tasks with Resume before the Status Date.

Finally, for a view, I set up a filter for the Flag field = Yes.

But, where do you find other variables such as [Status Date]. It doesn’t appear in the drop down list when you are building a formula. Are there other such variables?