Column Sharing in Report

Hi Amy, yes you can share many columns. In fact, my first "https://youtu.be/fzjSUG2jlyg" WFPro video was on shared columns and it shows you how to build and tear them apart. Thanks, Narayan

are these published somewhere? it would be amazing! It's so confusing searching these threads. We only need to combine 3 columns and I'm following the Advanced reporting instructions that shows how to add 2...can someone explain the concept to add a third? Do you follow the first step by inserting a blank column then recombining? Amy Larson Brandkey

Can you send me the code for this? I don't see it attached. Thanks! Leah Janz Metro Transit

Here's my favorite shared column view for issues that pulls 7 columns of data together in a decent format: column.0.displayname=Issue column.0.sharecol=true column.0.shortview=true column.0.textmode=true column.0.value= column.0.valueformat=HTML column.1.descriptionkey=referencenumber column.1.displayname=Request column.1.isInlineEditable=false column.1.linkedname=direct column.1.listsort=intAsInt(referenceNumber) column.1.namekey=referencenumber.abbr column.1.querysort=referenceNumber column.1.sharecol=true column.1.shortview=true column.1.textmode=true column.1.valuefield=referenceNumber column.1.valueformat=int column.2.sharecol=true column.2.shortview=true column.2.textmode=true column.2.value= column.2.valueformat=HTML column.3.descriptionkey=name column.3.isInlineEditable=false column.3.link.linkproperty.0.name=ID column.3.link.linkproperty.0.valuefield=ID column.3.link.linkproperty.0.valueformat=int column.3.link.lookup=link.view column.3.link.valuefield=objCode column.3.link.valueformat=val column.3.linkedname=direct column.3.listsort=string(name) column.3.namekey=name.abbr column.3.querysort=name column.3.sharecol=true column.3.shortview=true column.3.textmode=true column.3.valuefield=name column.3.valueformat=HTML column.4.sharecol=true column.4.shortview=true column.4.textmode=true column.4.value=

---

 Primary Contact: column.4.valueformat=HTML column.5.displayname=Primary Contact column.5.namekey=view.relatedcolumn column.5.sharecol=true column.5.shortview=true column.5.textmode=true column.5.valuefield=owner:name column.5.valueformat=HTML column.6.sharecol=true column.6.shortview=true column.6.textmode=true column.6.value=  Entry Date: column.6.valueformat=HTML column.7.descriptionkey=entrydate column.7.displayname=Entry column.7.isInlineEditable=false column.7.linkedname=direct column.7.listsort=atDateAsAtDate(entryDate) column.7.namekey=entryDate column.7.querysort=entryDate column.7.section=0 column.7.sharecol=true column.7.shortview=true column.7.sortOrder=1 column.7.sortType=asc column.7.stretch=100 column.7.textmode=true column.7.valuefield=entryDate column.7.valueformat=atDate column.7.width=150 column.8.sharecol=true column.8.shortview=true column.8.textmode=true column.8.value=  Latest Update: column.8.valueformat=HTML column.8.width=1 column.9.displayname=Request Latest Update column.9.namekey=latest update column.9.sharecol=true column.9.shortview=true column.9.textmode=true column.9.valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open for more)"), IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{noteText}))) column.9.valueformat=HTML column.10.sharecol=true column.10.shortview=true column.10.textmode=true column.10.value= column.10.valueformat=HTML column.11.namekey=latest update column.11.sharecol=true column.11.shortview=true column.11.textmode=true column.11.valueexpression=IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), CONCAT("(no updates)")) column.11.valueformat=HTML column.12.shortview=true column.12.textmode=true column.12.value= column.12.valueformat=HTML