Expand my Community achievements bar.

SOLVED

Display Condition color bubble in Project Report

Avatar

Level 4

I'm trying to figure out how to display only the Project Condition with the little green/yellow/red color bubble in a report. If I pull in the Condition field, there is no color bubble. If I pull in the Condition Update field, it has the color bubble but also has the last project level update the project manager made. 

 

First screenshot shows the Condition Update field. The first two rows are how I want it to look - just the condition with the colored bubble. THe third row is how I do not want it to look -- with the project owner's last update text posted on the project.

 

The second screenshot shows what it looks like when I pull in the Condition field instead. Solve the problem of the project owner text displaying, but it does not have the colored bubble. 

 

Thanks in advance!

 

AnnaHolder_0-1731694975811.png

 

AnnaHolder_0-1731703671250.png

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

to get that kind of result:

Rafal_Bainie_0-1731948118050.png

 

you need to:

1. add Condition field to a report

2. add conditional formatting for this column:

Rafal_Bainie_1-1731948267496.png

3. add Condition field one more time to the report

4. Go to 1st Condition field you added, switch to text mode, add this line of code:

sharecol=true

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

to get that kind of result:

Rafal_Bainie_0-1731948118050.png

 

you need to:

1. add Condition field to a report

2. add conditional formatting for this column:

Rafal_Bainie_1-1731948267496.png

3. add Condition field one more time to the report

4. Go to 1st Condition field you added, switch to text mode, add this line of code:

sharecol=true

Avatar

Level 4

That looks like it should work perfectly, I can give it a try. Thank you Rafal!