Need help with a value expression for a report | Community
Skip to main content
J
JuliaPh1
New Participant
January 31, 2024
Solved

Need help with a value expression for a report

  • January 31, 2024
  • 1 reply
  • 505 views

Hello! I currently have a column in an Issue report where the value expression is:

 

valueexpression=IF(ISBLANK({DE:OBO Window Closes}),ADDWEEKDAYS({project}.{plannedCompletionDate},-20),ADDWEEKDAYS({DE:OBO Window Closes},-2))

 

So right now if a custom field called "OBO Window Closes" is blank, this column displays a date that is 20 days prior to the Project Planned Completion Date. I've been asked to change the logic so that if "OBO Window Closes" is blank, this column displays a date that is 45 days prior to "Ship to Wholesalers Begins." This "Ship to Wholesalers Begins" is a date in a column in the report that is pulling the Planned Start Date of a task in the project task list called "Ship to Wholesalers."

 

The rest of the value expression can remain the same.

 

Can someone help me figure out how (or tell me whether it's even possible) to pull the planned start date of a task (or the date from another column) into this calculation?

 

Thank you!

Julia

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 skyehansen

The issue is able to pull the project date because the issue is inside the project. If the issue was inside your task, you'd similarly be able to pull your task date. 

1 reply

skyehansen
skyehansenAccepted solution
New Participant
January 31, 2024

The issue is able to pull the project date because the issue is inside the project. If the issue was inside your task, you'd similarly be able to pull your task date. 

Terms & ConditionsAccessibility statement

Loading footer...