Using a If statement using Contains for a project task field, to return a specific task due date | Community
Skip to main content
R
RichardCl1
July 28, 2023
Question

Using a If statement using Contains for a project task field, to return a specific task due date

  • July 28, 2023
  • 1 reply
  • 1251 views

Sorry having problems getting any value, true or false for the following script, and not sure why.

 

displayname=Delivery Date
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Shipping Ocean",{Project}.{Task}.{name}),{"dueDate"},"0"))
valueformat=HTML

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

1 reply

VicSellers
Community Advisor and Adobe Champion
VicSellersCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 28, 2023

Hi @richardcl1 - I would give the below a try! Let me know if it doesn't work.

 

 

displayname=Delivery Date listdelimiter=<div>​ listmethod=nested(tasks).lists​ textmode=true​ type=iterate​ valueexpression=IF(CONTAINS(“Shipping Ocean",{name}),CONCAT({plannedCompletionDate}),"")​ valueformat=HTML​

 

 

R
RichardCl1Author
July 28, 2023

displayname=Delivery Date
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Shipping Ocean",{name}),CONCAT({plannedCompletionDate"),"1")
valueformat=HTML

 

The above isn't returning any values still.  I stold the script from an example that was somewhat similar on the board, unfortunately still not getting it done.

 

My concern here is that this is a project level report, and I'm trying to run the IF statement at the Task level, to return the due date for the task.

R
RichardCl1Author
July 28, 2023

If I replace the Concat portion with a fixed value it returns a true statement value, so that's good, but I can't seem to get it to return the date, and it seems to return multiple true values for the single project line.

displayname=Delivery Date
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({task},{name}="Delivery Gate Meeting and Approval","2","1")
valueformat=HTML

 

 

Terms & ConditionsAccessibility statement

Loading footer...