What status code do I use for pulling "In Progress - Pending Approval" tasks in a report? | Community
Skip to main content
ChloeWY
ChloeWY
Level 6
June 21, 2023
Solved

What status code do I use for pulling "In Progress - Pending Approval" tasks in a report?

  • June 21, 2023
  • 2 replies
  • 1292 views

I'm working on a milestone report showing which Gates are Not started, In progress, and Complete.  I have that working, but I noticed tasks that are "In Progress - Pending Approval" don't pull the way "In Progress" tasks do. 

I looked around Experience League and tried adding an additional IF statement that looks for the status "INP:A", but that broke my entire column.  Does anyone have ideas?  

(The built in Milestone report doesn't meet our needs.)

Original, working column:  

displayname=Gate 1 Status
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(IF(CONTAINS("Gate 1 Approval",{name}),{status})="CPL","Complete",IF(IF(CONTAINS("Gate 1 Approval",{name}),{status})="INP","In progress",IF(IF(CONTAINS("Gate 1 Approval",{name}),{status})="NEW","Not started")))
valueformat=val

 

Attempt that led to a blank column:  

displayname=Gate 1 Status
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(IF(CONTAINS("Gate 1 Approval",{name}),{status})="CPL","Complete",IF(IF(CONTAINS("Gate 1 Approval",{name}),{status})="INP","In progress",IF(IF(CONTAINS("Gate 1 Approval",{name}),{status})="INP:A","Approval requested",IF(IF(CONTAINS("Gate 1 Approval",{name}),{status})="NEW","Not started")))
valueformat=val

 

Partial screenshot of report

 

Thank you!  

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

Hi Chloe,

 

You're right, "INP:A" is the right status to use for "In Progress - Pending Approval". However the syntax of your IF statement is not quite right. Try the following instead:

 

displayname=Gate 1 Status listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Gate 1 Approval",{name}),IF({status}="CPL","Complete",IF({status}="INP","In progress",IF({status}="INP:A","Approval requested",IF({status}="NEW","Not started"))))) valueformat=val

 

Let me know if that works.

 

Best Regards,

Rich. 

 

2 replies

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
June 21, 2023

I think you just need to add ":A" after the status. I know that "NEW:A" is New and waiting for approval.

 

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

    R
    Community Advisor
    Richard_Le_Community AdvisorAccepted solution
    Community Advisor
    June 21, 2023

    Hi Chloe,

     

    You're right, "INP:A" is the right status to use for "In Progress - Pending Approval". However the syntax of your IF statement is not quite right. Try the following instead:

     

    displayname=Gate 1 Status listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Gate 1 Approval",{name}),IF({status}="CPL","Complete",IF({status}="INP","In progress",IF({status}="INP:A","Approval requested",IF({status}="NEW","Not started"))))) valueformat=val

     

    Let me know if that works.

     

    Best Regards,

    Rich. 

     

      RandyRoberts
      Community Advisor
      RandyRobertsCommunity Advisor
      Community Advisor
      June 21, 2023

      Thanks Richard, I didn't even look at the IF statement.

      Terms & ConditionsAccessibility statement

      Loading footer...