Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Calculated Column for Work Start Date

Avatar

Level 2

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!

1 Reply

Avatar

Level 4

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