Workfront

JordanMa · 7/2/20

Hello - Has anyone created a report containing a field that only populates if the right selection is made? For example... If YES is selected, I want it on the report. If NO is selected, I don't want the NO or the Field Name to populate.

Let me know if any ideas? Thank you!

ElaineHe · 7/6/20

‚Hi, we have set up a report to show just those items with a yes against them on specific tasks. We set it up in Standard mode, but the below is what shows if I switch to Text mode. Governance Document Required is the column we are selecting Yes against.

DE:Governance Document Required=Yes

DE:Governance Document Required_Mod=in

JordanMa · 7/7/20

Thank you, I should have been a tad more specific. I still want the task and other info to show regardless of the selection, just don't want the field showing on the report depending on the selection. For now, I just have it formatted to indicate NA if No is selected and shall do for now!

AdinaPi1 · 7/9/20

What I do is create a new column rule and put a space in the Show Text option.

What I do for that is make a new column rule, and use a space for the Show Text option:

JordanMa · 7/9/20

Thank you, I've done that for now just to have it display NA. I would definitely do the space, however the field name will still populate but just show the "answer" as blank.

KatherineLa · 7/9/20

I might not be quite following, but are you trying to make the entire column itself disappear if a certain field is blank, or a report filter is answered a certain way?

If so, I think you could accomplish that in text mode by conditionally setting the width to 0 for that column if your condition were true. I'll be honest that I haven't tried it myself, but the basic building blocks to do that do exist.

That seems like an unusual use-case though, can you elaborate with a more specific example?

Katherine