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!
Views
Replies
Total Likes
Hello,
To subtract 20 days from a column, let's say subtract 20 days from Task 'Planned Start Date':
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
Views
Replies
Total Likes