Reporting on task completion

[NicoleCh7]

Hi All,

I'm having issues with a custom form calculated field.

If WIP milestone task "Production Completed" is complete (100%), this is true, what do i need to fix in the below formula?

IF({DE:PD - WIP Name}='Production Completed',IF({status}='CPL',"Yes",""))

Thanks

[JustinRenteria2]

I believe it's because the first IF statement in your code does not have a value for when Name is not equal to Production Completed. It should look something like this, my addition is in Red font.


IF({DE:PD - WIP Name}='Production Completed',IF({status}='CPL',"Yes","")  , You need to add something here)

[skyehansen]

this worked for me, but I'm not clear in what you mean when you say "I'm having issues". What behavior are you seeing? Since it worked for me, I wonder if it's just the case of you having forgotten to toggle one of the checkboxes on the calculated field (the one about "apply to existing calculations"). Otherwise it could be that there's a typo somewhere in your calculation (either the name of the field, what the field option was, or some misunderstanding of what a milestone task is).

[NicoleCh7]

Thank you. It looks like the "apply to existing calculations" was the issue. I thought pressing apply was enough but didnt see the other selection.. 

It worked straight as i had the formula. Thanks