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
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Thanks for flagging this @Tegwyn Stockdale I stumbled upon it because of your message. We definitely can use this as well I'm seeing a series of commas in some places in the Current Task column. Anyone have suggestions for stripping these out ? Catherine Hayes Manager, Business Analytics and Program Operations The Channel Company Westborough MA
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes