Using 'contains' in collection reports | Community
Skip to main content
J
Jcosta16
Level 2
October 19, 2023
Solved

Using 'contains' in collection reports

  • October 19, 2023
  • 2 replies
  • 1618 views

Hi! Was hoping to see if this group could help me with some text mode - Trying to pull in a task name, but I can only pull it in if it' EXACTLY what's in the quotes - is there a contains feature I could use instead, so that if the task contains 'Transmittal T1' the rest doesn't matter?

 

valueexpression=IF({name}="Transmittal T1 - Client Feedback Due",CONCAT({actualCompletionDate}))

 

Additionally, is there a formula I could use to show projected completion date if an actual does not exist? I'd like it to pull either/or, and then note which one it is. Thank you!

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

Yep, it's actually CONTAINS

 

CONTAINSThis expression returns true if the findText string is found within the withinText string and is formatted as follows:
CONTAINS(findText, withinText)

 

So: IF(CONTAINS("Transmittal T1",{name}),CONCAT({actualCompletionDate}))

2 replies

VicSellers
Community Advisor
VicSellersCommunity Advisor
Community Advisor
October 19, 2023

I would give this a try, let me know if it doesn't work!

 

 

valueexpression=IF(CONTAINS(“Transmittal T1",{name}),CONCAT({actualCompletionDate}),"")

 

 

​On your second question, wouldn't Actual Completion Date always exist...? I can't think of an object in Workfront where it wouldn't

J
Jcosta16Author
Level 2
October 19, 2023

I meant if there's no actual completion date yet, can we show the projected completion date? 

VicSellers
Community Advisor
VicSellersCommunity Advisor
Community Advisor
October 19, 2023

Ah, I had Planned Completion Date on the brain - my bad! I'm not positive on that part of the text mode (might want to post a new thread with just that text mode being requested to get a fresh set of eyes on it)

The_Real_Melinda_Layten
The_Real_Melinda_LaytenAccepted solution
Level 3
October 19, 2023

Yep, it's actually CONTAINS

 

CONTAINSThis expression returns true if the findText string is found within the withinText string and is formatted as follows:
CONTAINS(findText, withinText)

 

So: IF(CONTAINS("Transmittal T1",{name}),CONCAT({actualCompletionDate}))

J
Jcosta16Author
Level 2
October 19, 2023

This one worked!! Thank you!

Terms & ConditionsAccessibility statement

Loading footer...