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

ShawnMe
ShawnMe
Offline

Badges

Badges
0

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
25

Posts

Posts
42

Discussions

Discussions
2

Questions

Questions
40

Ideas

Ideas
2

Blog Posts

Blog Posts
0
Top badges earned by ShawnMe
Customize the badges you want to showcase on your profile
Re: How to compare dates in a report to mark tasks Early, Late, or On Time. - Workfront 03-08-2020
Hi Skye, Sorry, I had to let this go for the weekend and try to go at it with fresh eyes today. I was able to make the CLEARTIME syntax work on the calculation of the number of days between the Requested Due Date and the Actual Completion Date, but the calculation is still off in some circumstances. It makes me wonder if I am experiencing the same issue that you are. What I wasn't able to make work was adding CLEARTIME into the Early/Late/OnTime expression. I am going to give both another shot t...

Views

38

Likes

0

Replies

4
Re: Report showing projects shared with User. - Workfront 31-07-2020
So far so good! Seems to be working beautifully. Thanks again, Skye. Shawn

Views

36

Likes

0

Replies

0
Re: Report showing projects shared with User. - Workfront 31-07-2020
Thank you very much, Skye! Nice you meet you and the group, as well. I will give it a try.

Views

36

Likes

0

Replies

0
Re: How to compare dates in a report to mark tasks Early, Late, or On Time. - Workfront 29-07-2020
Thank you. Is the time Noon-2pm PST? If so, I will only be able to make the first hour.

Views

38

Likes

0

Replies

0
Re: How to compare dates in a report to mark tasks Early, Late, or On Time. - Workfront 28-07-2020
Hi Narayan, I am a little familiar with the WFPro site, but not the sessions. What would I have to do to attend? Thanks,Shawn

Views

38

Likes

0

Replies

3
Re: How to compare dates in a report to mark tasks Early, Late, or On Time. - Workfront 27-07-2020
It is a date field without the time being displayed.

Views

38

Likes

0

Replies

0
How to compare dates in a report to mark tasks Early, Late, or On Time. - Workfront 24-07-2020
I am trying to compare a custom data field (Requested Delivery Date) to the Actual Completion Date to be able to label tasks Early, Late, or On Time in a report column. Among the expressions/text blocks I have tried are the following: displayname=Timing1textmode=truevalueexpression=IF({actualCompletionDate}={DE:Requested Delivery Date},"On Time",IF({DE:Requested Delivery Date}>{actualCompletionDate},"Early",IF({actualCompletionDate}>{DE:Requested Delivery Date},"Late","")))valueformat=HTML displ...

Views

38

Like

1

Replies

15
Projects tab or report showing projects shared with User - Workfront 17-07-2020
Users who need to reference projects without being assigned tasks often have a hard time finding projects, leading them to leave updates on their requests, which are easier to find but have already been converted. It is unreasonable to expect these Users to search through the All Projects list or save every project as a favorite, assuming they receive a notification that allows them to navigate to the project in the first place.The best option would be if these projects would show up in the Proj...

Views

3

Like

1

Replies

0
Re: Referencing project custom data in an IF statement on a task report. - Workfront 16-07-2020
Thank you very much, Anthony. That worked. Luckily I do not have to sort by this column—your sorting note is good to know, as well.

Views

14

Likes

0

Replies

0
Referencing project custom data in an IF statement on a task report. - Workfront 15-07-2020
I am relatively new to text mode, and I would like a column in a Task Report to pull custom data from the Project if it is not available in the Task. For instance, Primary Contact is a custom data field we use on both Task and Project custom forms. When I run the task report I am working on, I would like the Primary Contact column to display the Primary Contact from the Project if there is no entry in that field at the Task level. This would alleviate the need to add custom forms and duplicate d...

Views

14

Likes

2

Replies

2