The 2nd Coolest Textmode Column I Invented This Week | Adobe Higher Education
Skip to main content
Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
March 17, 2017
Pergunta

The 2nd Coolest Textmode Column I Invented This Week

  • March 17, 2017
  • 16 respostas
  • 1811 Visualizações

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

Este tópico foi fechado para respostas.

16 Respostas

Mostrar respostas anteriores
C
catherineh70969
Level 6
May 6, 2019

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

T
TegwynSt1
Level 6
May 6, 2019
I get that too ---i think it's when you have more than one task that could possibly begin...?? didn't have time to look into as far as predecessor set up. are you at LEAP? Tegwyn Stockdale Production Coordinator / PM BayCare Clearwater, Florida Baycare Health System, Inc.
D
DavidCo3
Level 10
May 8, 2019
Try using the below for the listdelimeter line: listdelimiter= ­ As another option, if you would like to see your tasks going down the page (one per line), use the following:\ listdelimiter= David Cornwell
C
catherineh70969
Level 6
May 10, 2019
That did it. Thanks so much @David Cornwell ! Catherine Hayes Manager, Business Analytics and Program Operations The Channel Company Westborough MA
Richard_Carlson
Community Advisor
Richard_CarlsonCommunity Advisor
Community Advisor
May 13, 2019
@David Cornwell how would you go about switching from '|' to '//' as a task separator? Richard Carlson Behr Process Corporation
D
DavidCo3
Level 10
May 14, 2019
Hi Richard - you just change the pipe symbol to whatever you like in the valueexpression. See below with the // instead of the |. valueexpression=IF({numberOfChildren}>0,"",IF(ISBLANK({handoffDate}),"",IF(ISBLANK({actualCompletionDate}),CONCAT(" // ",{name}),""))) David Cornwell
Termos e condiçõesAccessibility statement

Loading footer...