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