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 ------Original Message------ Where is the attachment you are referring to? Delphine Campes Director of Project Management & Marketing Campaigns Pluralsight