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
Running into and error when trying to choose from a custom field drop down menu. - Workfront 21-12-2020
I keep running up against the error "Invalid Parameter: conversion to type DTTM value "false"" when trying to enter the deliverable type from a drop down menu in a task custom form. I only get the error from the deliverable field, and only on that task. I can add the same custom form to other tasks and fill in the field with no issues. Does anyone know what the error means and how to get around it without creating a replacement task?

Views

9

Likes

0

Replies

2
Re: Autocomplete in New Experience - Workfront 04-12-2020
Thanks, Hannah. Regards, Shawn

Views

17

Likes

0

Replies

0
Re: Autocomplete in New Experience - Workfront 03-12-2020
Hi Kyna, This is a Workfront feature, not a browser feature. I was not sure of the correct name for it. Typeahead it is, apparently. The function still exists when entering custom forms data while converting or creating new projects or tasks. But when you want to add information to an existing custom form on the Project/Task Details tab, or in the popup box when selecting a task custom form when available in a Project view, previous entries do not appear while you type. In Classic, this saves me...

Views

17

Likes

0

Replies

0
Autocomplete in New Experience - Workfront 30-11-2020
I just migrated to New Experience and it seems that there is no autocomplete feature in custom form single line text fields when editing on the Project Details tab, though there is in Classic. I could not find anything about this in One. Is this a feature that is coming? Thanks.

Views

17

Likes

3

Replies

4
Re: Syntax for cross-object references in valueexpressions. - Workfront 06-08-2020
I'll do you one better. In going through another report just now, I realized that I previously made a similar reference successfully. Why I couldn't figure it out this time is anybody's guess.

Views

24

Likes

0

Replies

0
Re: Syntax for cross-object references in valueexpressions. - Workfront 06-08-2020
Ah. The issue was using a period instead of a colon between {project} and {DE:Requester}. You actually used a colon the first time, which is what I thought it should be and had used in all of my attempts. Your second post corrected it. Thank you very much, again, Anthony.

Views

24

Likes

0

Replies

0
Re: Syntax for cross-object references in valueexpressions. - Workfront 06-08-2020
Argh. ISEMPTY is a remnant from my FileMaker days. Thanks for catching that, Anthony. Unfortunately, replacing ISEMPTY with ISBLANK did not make any of the listed expressions work. So something is wrong with the project:Requester syntax.

Views

24

Likes

0

Replies

5
Syntax for cross-object references in valueexpressions. - Workfront 05-08-2020
Hi, I am trying to write an IF statement that enters either 1) the data from a task's custom field (Requester) or 2) the data from the same field on the project level. I can't find the syntax anywhere here or in the documentation. I have tried valueexpression=IF(ISEMPTY({DE:Requester}),{DE:project:Requester},{DE:Requester})valueexpression=IF(ISEMPTY({DE:Requester}),{DE:project}:{DE:Requester},{DE:Requester})valueexpression=IF(ISEMPTY({DE:Requester}),{project:DE:Requester},{DE:Requester})valueexp...

Views

24

Likes

4

Replies

7
Re: How to compare dates in a report to mark tasks Early, Late, or On Time. - Workfront 03-08-2020
Thanks again, Skye. It was driving me batty.

Views

38

Likes

0

Replies

0
Re: How to compare dates in a report to mark tasks Early, Late, or On Time. - Workfront 03-08-2020
I was actually able to get it to work by mostly starting from scratch and simplifying the nested IF that determines the field to compare with the Actual Completion Date. But now that you mention only using CLEARTIME on the Actual Completion Date, I think that was the issue. Here is what works. valueexpression=IF(WEEKDAYDIFF(CLEARTIME({actualCompletionDate}),IF(ISBLANK({DE:Requested Delivery Date}),{DE:Meeting / Due Date},{DE:Requested Delivery Date}))=0,"On Time",IF(WEEKDAYDIFF(CLEARTIME({actual...

Views

38

Likes

0

Replies

0