Column Sharing in Report

Hi Nate, I came across this helpful thread today and wondered if you had moved the text expressions? The link you gave last year no longer works: https://communitybeta.workfront.com/p/do/si/topic=82. I checked out the Resources section but there hasn't been anything added to the Report Templates & Expressions File Base page since last June. Is there a central place for users to share text mode/expressions they've figured out? I added this in the Idea Exchange a few weeks ago but wanted to reach out after coming across this thread. Thanks! Ondina

Sorry bout that Onida! We deactivated the old subdomain "communitybeta" which may have screwed with some older links. Try this link instead: https://community.workfront.com/p/do/si/topic=82 On Wed, May 31, 2017 at 2:19 PM, Ondina Sturges < reportingforum@communitylists.workfront.com> wrote: > Hi Nate, > > I came across this helpful thread today and wondered if you had moved the > text expressions? The link you gave last year no longer works: > https://communitybeta.workfront.com/p/do/si/topic=82. I checked out the > Resources section but there hasn't been anything added to the Report > Templates & Expressions File Base page since last June. Is there a central > place for users to share text mode/expressions they've figured out? I > added this in the Idea Exchange a few weeks ago but wanted to reach out > after coming across this thread. Thanks! Ondina > > -----End Original Message----- > -- NATE BAGLEY Workfront Community Manager [image: Workfront] https://www.workfront.com O 801.477.9712 | M 801.706.3295 natebagley@workfront.com | www.workfront.com Address https://www.workfront.com/contact-us | Twitter https://twitter.com/Workfront_Inc | LinkedIn https://www.linkedin.com/company/48453 | Facebook https://www.facebook.com/workfront [image: Workfront] https://www.workfront.com/email-promo

Where is the attachment you are referring to? Delphine Campes Director of Project Management & Marketing Campaigns Pluralsight

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