Skip to main content
NicoleCh7
Level 1
May 12, 2025
Solved

Reporting on task completion

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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
skyehansen
skyehansenAccepted solution
May 13, 2025

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).

View in thread

8 replies

JustinRenteria2
JustinRenteria2
Level 6
May 12, 2025

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)

Translate
    skyehansen
    Adobe Champion and Community Advisor
    skyehansenAdobe Champion and Community AdvisorAccepted solution
    May 13, 2025

    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).

    Translate
      NicoleCh7Author
      Level 1
      May 13, 2025

      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

      Translate
        AC-again
        Level 2
        July 29, 2025

        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.
        Translate
        kautuk_sahni
        Adobe Employee
        kautuk_sahniAdobe Employee
        Adobe Employee
        July 29, 2025

        @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!

        Translate
        Kautuk Sahni
        Terms & ConditionsAccessibility statement

        Loading footer...