Expand my Community achievements bar.

If/Then Statement

Avatar

Level 2
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
3 Replies

Avatar

Level 4
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

Avatar

Level 2
Thank you David, that worked great, but now I cannot inline edit in the report. Any ideas? Ryan Eide Amazon - ERMC

Avatar

Level 10
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