0

I am very new to MS Project and I am struggling to create a Look-Ahead formula for a flag field in a master project file (collection of sub projects). I can't seem to get even the simplest formula to work-

IIf([Start]>[Status Date],Yes,No)

Everything looks as if it is defaulting to "No" and I am so new to MSP that I don't know why.

Custom Flag Formula

Master Project

I'm almost sure that I am misunderstanding something fundamental, I just need someone to point out where I am being a dunce.

Improve this question

1 Answer 1

Reset to default
1

Assuming you have a linked project structure, then the sub-projects reside in separate files. In that case you need to open each source file directly (not as a subproject) to modify and save the custom field formulas.

Improve this answer
1
  • Thank you. Turns out I needed to update each source file and assign a Status Date to each. My master had a Status Date but none of my sub projects had them (thus all the "No"s across the board). I also found a VBA script here to update the Status Date of all sub projects.
    – SeaSkyShore
    Jun 4, 2019 at 23:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.