Skip to main content
S
SarahSt6
Level 2
November 17, 2022
Question

Calculated Column for Work Start Date

  • November 17, 2022
  • 1 reply
  • 617 views

I am working on a report and want to create a calculated date column that shows when the user needs to start work. The user needs to plan for their work and would like to see what date(s) the work should start - they need to start 20 business days before the in-market start date, so I'd like the report to have a column that has that custom date. I'm having trouble figuring out exactly how to create this calculated column in the report as text mode is not always my strong suit. Any assistance would be appreciated!

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

1 reply

_Manish_Singh
_Manish_Singh
Level 9
November 18, 2022

Hello,

To subtract 20 days from a column, let's say subtract 20 days from Task 'Planned Start Date':

  • Convert 'Planned Start Date' column to text mode (sort it before converting if necessary)
  • Copy it to another column and use 'valueexpession' instead of 'valuefield' (highlighted in red). Plus, apply necessary function (doc shared below)
  • Functions guide: Calculated data expressions | Adobe Workfront

 

Example: Text mode for Task Planned Start - 20 days

descriptionkey=plannedstartdate
displayname=Planned Start - 20 Days
isInlineEditable=false
linkedname=direct
listsort=atDateAsAtDate(plannedStartDate)
namekey=start.on
querysort=plannedStartDate
section=0
shortview=false
stretch=0
textmode=true
valueexpression=ADDDAYS({plannedStartDate},-20)
valueformat=atDate
width=75

Terms & ConditionsAccessibility statement

Loading footer...