Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

[VIDEO] Top 3 reasons to create a Shared Column Report

Avatar

Employee

Howdy folks!  Your "On-Demand Workfront CSM" @CynthiaBoon is back with another “Top 3” video!  

 

Looking for new, efficient ways to present your information in a report? Give the Shared (or Summary) Columns idea a try! 

We get lots of questions on how to use Text Mode to combine information into a report, so we have a step-by-step video as well as some resources below to get you started. 

 

 

First thing! As promised, here is the documentation article on how to get started with building a shared column.  

 

View: merge information from multiple columns in one shared column 

 

In the video, I reference some slightly different text mode than from the Experience League article (link above), so the code that I use in the demo is provided below.   

 

Pro-tip:  Sometimes Text Mode doesn't copy and paste well so you may have to retype it into a reference document, but at least this is pretty short.  

 

In the video – when I talk about the "Blank" column - copy over anything that might be showing and replace it with this:  

value=<br>  

valueformat=HTML  

width=1  

sharecol=true  

value=</b></font><hr><font color=000000><b> x  </b></font>  

 

In the video – when I talk about the "Workfront Object" column - just add this to the end of the existing Text Mode, without changing anything else  

 sharecol=true  

 

Bonus Tip #1: To change the Display Name on the Column Name  

 displayname=  

 

 Bonus Tip #2: For the "Font Color" change   

You can change the standard black font (Black =000000) to whatever you would like, example:  Red=FF0000  

 

Bonus Tip #3: For the "Label" change  

Where the placeholder "x" is: that is where you want to put the "label" of that value, example Project Owner or Status or % Complete, etc.  

 

NOTE: For those in the know, you probably noticed that I forgot to add a “Blank” column in front of the “Owner” column, which is why it didn’t have a label. You can always go back and add it, like I did. (Screenshot below. ) 

 

Top 3 - Shared or Summary Column Report - Final.png

3 Replies

Avatar

Level 7

Thanks!  I've built shared column reports before, but the process was very laborious (and a lot of trial-and-error).  This is much easier, and the formatting makes everything so much cleaner.

Avatar

Level 2

Thank you Cynthia!  Great report and appreciate the detailed steps you provided, my first time working with text mode but you made it easy!

Avatar

Former Community Member

Thanks Cynthia, this is my happy place for when I need to create shared columns.

The best method and explanation there is!

Thanks

Matt