The 2nd Coolest Textmode Column I Invented This Week
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