Template Task ID in If Statement Value Expression | Community
Skip to main content
MoniqueEvans
Community Advisor
MoniqueEvansCommunity Advisor
Community Advisor
September 13, 2022
Solved

Template Task ID in If Statement Value Expression

  • September 13, 2022
  • 2 replies
  • 883 views

Me again! I have a project report with a task collection column; however, I need to add an if statement so that I'm only showing tasks with a specific template task ID. I'm not the strongest at writing IF statements so I'm hoping someone can help me out, here's what I have:

valueexpression=IF({templateTaskID}=5dd5663500ff47591adfff99283675a2,CONCAT({parent}.{name},'-',{name},' - ',{plannedCompletionDate}))

Thanks again @skyehansen for your help on getting the parent name to display!!

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 imgrund

Hi - Monique!!

 

So I did a test, you need both the quotes around the ID, but you also need the false part of your IF statement

 

displayname=Test for Monique
listdelimiter=<br>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({templateTaskID}="6090bfb100237396fd3dcbc4f8944395",CONCAT({parent}.{name},'-',{name},' - ',{plannedCompletionDate}),"")
valueformat=HTML

2 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
September 13, 2022

my off-the-couch reaction would be to wonder if putting quote marks around the GUID would help. (double quotes is what I usually use there)

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAccepted solution
    Adobe Employee
    September 13, 2022

    Hi - Monique!!

     

    So I did a test, you need both the quotes around the ID, but you also need the false part of your IF statement

     

    displayname=Test for Monique
listdelimiter=<br>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({templateTaskID}="6090bfb100237396fd3dcbc4f8944395",CONCAT({parent}.{name},'-',{name},' - ',{plannedCompletionDate}),"")
valueformat=HTML
      MoniqueEvans
      Community Advisor
      MoniqueEvansCommunity AdvisorAuthor
      Community Advisor
      September 14, 2022

      I appreciate you and @skyehansen SO MUCH!!! I tried so many combinations between using TTSK, adding dots, moving the curly brackets. Never once did "put the ID in quotes" come to mind.

      Y'all are truly the best, I was losing my mind trying to think where I went wrong.

      A million thank yous.

       

      Hopefully, someone else can benefit from this one too!

      Terms & ConditionsAccessibility statement

      Loading footer...