How do i populate manually created Insvc Milestone date field in status report based on condition?

Datha prasadred
Tera Contributor

In the SPM(ITBM) we do have projects in any project will have milestones 

Requirement: How do i populate Insvc Milestone date in status report based on condition when Insvc milestone is true and state is open then it should populate  Insvc Planned start date in status report if it is false and state is not open then it should check for the next insvc milestone true and state is open that date should populate and also once the first Insvc milestone is true and state is closed then only the other insvc milestone date should populate( Insvc milestone true and state is open should populate)..

 

As of now I only created Insvc milestone date filed please help me with this requirement..

 

Insvc Milestone.png

1 REPLY 1

Datha prasadred
Tera Contributor

Please help on the above requirement..