Calculated Field "IF statement" issue

[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 · Accepted solution]

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

[AC-again]

We are having issues with an IF statement that is not showing the expected value. I am adding a couple of lines, it has 138 lines.

IF({DE:Originals | Tournament Name}="AMERICAS Bupa Championship","Tulum, MEX",

IF({DE:Originals | Tournament Name}="AMERICAS 69th Brazil Open at Rio Olympic Golf Course","Rio de Janeiro, BRA",

))

The expected result is to see the location ("Tulum, MEX") associated with the name ("AMERICAS Bupa Championship") that is selected in a previous pulldown field.

[skyehansen]

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/reporting-on-task-completion/m-...

sounds like you’re adding to an existing calculation? have you clicked the “apply to existing calculations” checkbox yet?

[AC-again]

Thanks, the "apply to existing calculations" did the trick.

[KervinWelsch2]

Hi @AC-again 

The issue with your expression is that the second IF does not have an "else" value (i.e., a value to return if the condition is false). This breaks the logic of the function.
Suggested correction:
You can simply return an empty string (" ") or another default value when none of the conditions are met. Like this:

IF({DE:Originals | Tournament Name}="AMERICAS Bupa Championship","Tulum, MEX",
IF({DE:Originals | Tournament Name}="AMERICAS 69th Brazil Open at Rio Olympic Golf Course","Rio de Janeiro, BRA",""))

Please let me know if worked, have a good day

[kautuk_sahni]

@NicoleCh7 Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!