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

HrugDe
HrugDe
Online

Badges

Badges
14

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
19

Posts

Posts
23

Discussions

Discussions
2

Questions

Questions
21

Ideas

Ideas
2

Blog Posts

Blog Posts
0
Top badges earned by HrugDe
Customize the badges you want to showcase on your profile
Re: Checking if field data = numeric value (equivalent of ISNUMBER)? - Workfront 22-05-2020
Thanks Doug. On the last suggestion, can you please elaborate? Do you mean format the custom form field as a Number? Anything else I can do to reject non-numeric input?

Views

12

Likes

0

Replies

0
Checking if field data = numeric value (equivalent of ISNUMBER)? - Workfront 22-05-2020
We have an issue where some users accidentally enter a non-numeric value in a custom field. This has resulted in downstream issues with some of the python/API scripts that we run to load data into projects. I'd like to create an exception report where I could check if the custom field has a non-numeric value and where the field is not blank. I reviewed the list of expressions available in WF and didn't see anything that would work. Anyone have any creative suggestions? Thank you!

Views

12

Likes

2

Replies

4
In-line Editing Commit Dates in Task Reports - Workfront 27-04-2020
Is there any way we can allow Commit Dates to be edited in-line in task reports? It would be VERY helpful for our users to be able to edit Commit Dates directly from a report. Some of our users have 100+ active tasks so using the Home screen or My Work screen isn't very helpful because we need to show them contextual information about the project for every task that they are assigned to. We don't have enough flexibility with how Home or My Work are designed to show that much information in a row...

Views

5

Likes

4

Replies

0
Re: Tips on using "ciin" conditional modifier in filter text mode - Workfront 16-04-2020
Yas! Thank you. This is cleaner and I can remove the custom calced field. Appreciate the community's help with this. I have now also been introduced to wf-pro.com so it's a double-whammy.

Views

20

Likes

0

Replies

0
Re: Filter: not blank AND not 'x' - Workfront 16-04-2020
Yay for WF-pro.com!!!

Views

19

Like

1

Replies

0
Re: Tips on using "ciin" conditional modifier in filter text mode - Workfront 16-04-2020
In case it helps anyone else, here is the code that I ended up with. This is a slightly different report than what I posted above, but same concept as discussed in this thread: name=Test task namename_Mod=cicontainsproject:name=Jackproject:name_Mod=cinotcontainsproject:status=CURproject:status_Mod=inreferenceNumber=1539937referenceNumber_Mod=nestatus=NEW INPstatus_Mod=inDE:project:Factory 1 Country=China Taiwan CH TW Vietnam Cambodia VTDE:project:Factory 1 Country Blank=BlankDE:project:Factory 1...

Views

20

Like

1

Replies

1
Re: Tips on using "ciin" conditional modifier in filter text mode - Workfront 16-04-2020
No, that didn't work. Unable to get the code to save when I add two different filters for the same field in the same AND statement. As a workaround, I created a calculated field to check if the "Factory 1 Country" field is blank and it will return "Blank". I added that one to the same AND statement and it's all gravy! Thanks again for all the help.

Views

20

Likes

0

Replies

5
Re: Tips on using "ciin" conditional modifier in filter text mode - Workfront 16-04-2020
Thank you Doug! The tab instead of a comma worked! Now this got me thinking; what I would rather do with this report is use the "cinotin" conditional modifier with a shorter list of variables. This also worked using the TAB spacing you recommended! However, the report now brings in blanks. Any way to combine a list of variables in "cinotin" along with filtering out blanks?

Views

20

Likes

0

Replies

0
Re: Tips on using "ciin" conditional modifier in filter text mode - Workfront 15-04-2020
So I got "in" to work with the comma separated values, but I would really love the case insensitive version...

Views

20

Likes

0

Replies

0
Tips on using "ciin" conditional modifier in filter text mode - Workfront 14-04-2020
Hello, I have a task report with a set of filters in text mode. I am trying to filter only tasks where the project-level custom field, "Factory 1 Country" is one of the 10 options listed in the code below. This field is setup as a text field. Rather than create individual OR instances to account for each of the 10 different entries I am filtering for, I thought I could use the "ciin" conditional modifier. However, this is not working. Any insight on why this isn't working? Is it because the fiel...

Views

20

Likes

3

Replies

14