Calculated Field For First Proof Due Date

[AbiBeggs]

Hi All,

Our team has requested to see the date the first proof for a design project would be due when looking at and approving request. I think a calculated field would be able to capture that. 

We currently have a field 'What tasks are needed for this project?' where graphic design is selected and another field 'Project Effort Level'. The project effort level (low, medium, high) indicates what template to use. Low has a duration of 3 days prior to first proof due, medium has a duration of 6 days, and high has a duration of 10 days. So if graphic design is selected and low is selected I think we would just need to add 3 days to the current date or entry date. Does anyone have any suggestions on how to best structure this calculation?

[skyehansen]

For me the ideal configuration would be to set the Project Effort Level to be formatted as a number, then click "show values" on your choices, and set the values as being 10, 6 and 3.

This would reduce your final calculation to something like,

IF(CONTAINS('Graphic Design',{DE:TasksNeeded}),ADDWEEKDAYS({entryDate},{DE:ProjectLOE}))

Otherwise you would have to set up separate if/then pairs for the different selections. I'll link to the calculated data expressions page so you can fight that out yourself.

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/...