Skip to main content
Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStore
New Participant
March 17, 2017
Question

The 2nd Coolest Textmode Column I Invented This Week

  • March 17, 2017
  • 16 replies
  • 1811 views

I'd hoped to write this one up as a blog, but Earth simply spins too quickly, so instead, I'd like to invite you to try out this textmode gem I invented this week. In fact, let's at least make a game of it!

WARNING: If you're going to play, WAIT to read the other threads below, and SPOILER ALERT: this may lead to editing ALL of your Project Reports and Views.

Create or edit a Project Report

Add a column

Switch to Text Mode

Paste in the definition below

Save and run the report

Examine the results in the column

Scroll down and add what you think this does, how much time it will save your users, and how else it might Change Your Workfont Life

Scroll back up and read what others thought, save, and are taking it next

Enjoy, and thanks for playing!

Regards,

Doug

displayname=Current Task(s)

listdelimiter=

listmethod=nested(tasks).lists

textmode=true

type=iterate valueexpression=IF({numberOfChildren}>0,"",IF(ISBLANK({handoffDate}),"",IF(ISBLANK({actualCompletionDate}),CONCAT(" | ",{name}),""))) valueformat=HTML

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

16 replies

Show previous replies
DavidCo3
Level 10
March 20, 2017
Very nice, Doug! I made a slight change and am using // to separate the task names rather than a pipe. Will share with our teams and I'm sure they will love it. Cheers
OndinaSt
Level 4
March 17, 2017
This is great Doug!! We are still in initial configuration so just wrapping our heads around reporting & text mode. I can see this column being extremely helpful - thank you for posting!!
Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAuthor
New Participant
March 17, 2017
Client 4: This one is worth going through with the COO tomorrow as it might even remove a report from the meeting dashboard, saving the whole team time every week.
Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAuthor
New Participant
March 17, 2017
Client 3: Doug, as per my message, this new report immediately pointed out some problems with the templates that are being used where predecessors are pointing to incorrect tasks showing tasks as ready to go when they aren't. It also showed some incomplete tasks. This one's a keeper! -- Chad
Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAuthor
New Participant
March 17, 2017
Client 2: I like it! And will share it with Lyza. It can also be used as a “clean up” report to show tasks that we missed completing. Obviously, the first 2 tasks in the report have predecessors complete in reality or we would not be working on them (hopefully, anyway!), but having this new column on the report makes template and/or project dependency errors jump out at us. Thanks again! Theresa
Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAuthor
New Participant
March 17, 2017
Client 1: Hi Doug, That is great! This is what we are asked every weekly meeting! Thanks, Philip
Terms & ConditionsAccessibility statement

Loading footer...