If/Then Statement | Community
Skip to main content
R
RyanEi
Level 2
July 16, 2019
Question

If/Then Statement

  • July 16, 2019
  • 3 replies
  • 852 views
Does anyone know how to do a If/Then statement in the reporting. My tasks have a custom notes field and I only want to show the notes at the parent task level, below is how this would look: If parent is a project (identifying top level tasks) Show task note If parent is a task Show parent task note I'm not sure if this is possible in WF but wanted to check with the community. Ryan Eide Amazon - ERMC
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

D
DavidTa1
Level 4
July 16, 2019
Ryan, Here is one way to get what I believe you are looking for. The code is: valueexpression=IF({indent}=0,{lastNote}.{noteText},{parent}.{lastNote}.{noteText}) valueformat=HTML Let me know if you have any questions. Thanks!! David
DAVID A. TAYLOR SVP, Managed Services
R
RyanEiAuthor
Level 2
July 16, 2019
Thank you David, that worked great, but now I cannot inline edit in the report. Any ideas? Ryan Eide Amazon - ERMC
imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
July 16, 2019
Thanks, David! I did not know about the Indent field before. I've used IF or report filters that will say Task Number equals 1 to cover the "project" task. This is much cleaner! Anthony Imgrund FCB
Terms & ConditionsAccessibility statement

Loading footer...