Using 'contains' in collection reports

Question

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!

The_Real_Melinda_Layten · Accepted Answer

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}))

VicSellers · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO