Skip to main content
CynthiaBoon
Adobe Employee
Adobe Employee
Aug 21, 2023 8:33 PM UTC

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

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. 😉) 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

5 replies

KristenS_WF
Level 7
Aug 22, 2023 5:46 PM UTC

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.

Translate
Level 2
Oct 2, 2023 3:21 PM UTC

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

Translate
Oct 18, 2024 5:33 PM UTC

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

The best method and explanation there is!

Thanks

Matt

Translate
Level 2
Jul 1, 2025 2:08 PM UTC

Thank you, Cynthia!  This is where I come to stay sane while working through shared column.  Truly the most helpful and clear guide I’ve come across.

Translate
CynthiaBoon
Adobe Employee
Adobe Employee
Jul 11, 2025 12:15 AM UTC

Yay!  It took several attempts to record it without messing up (the bloopers are hilarious), so I'm glad it was helpful! 🙂

Translate