Calculated Field For First Proof Due Date | Community
Skip to main content
A
AbiBeggs
January 15, 2025
Question

Calculated Field For First Proof Due Date

  • January 15, 2025
  • 1 reply
  • 389 views

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?

 

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

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
January 15, 2025

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/calculated-data-expressions

 

Terms & ConditionsAccessibility statement

Loading footer...