Reporting on task completion | Community
Skip to main content
N
NicoleCh7
May 12, 2025
Solved

Reporting on task completion

  • May 12, 2025
  • 3 replies
  • 714 views

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
Best answer by 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).

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

    skyehansen
    Community Advisor
    skyehansenCommunity AdvisorAccepted solution
    Community Advisor
    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).

      N
      NicoleCh7Author
      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

        A
        AC-again
        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.
        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        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!

        Kautuk Sahni
        Terms & ConditionsAccessibility statement

        Loading footer...