We have a project report that is currently summarizing project-level
custom form information per project, and to that we're looking to add an
average of a value in a custom field in the issues for those projects.
Is this even possible? I've been digging through the documentation and
community posts ...
Hi Everyone ‚Äì my presentation for the Workfront Skill Exchange went
live today! There were a lot of calculation examples in the presentation
and I wanted to create a space here on the Community to share those so
you can easily copy and paste them into your instance. Also, if you
attended and didn’...
Hi everyone, I'm trying to create buckets for tasks with IF statement,
but for some reason I'm getting wrong results. Does anyone see any
aparent flaw in this calculation:IF(Planned Hours>5,">5h",IF(Planned
Hours>3,"(3-5h]",IF(Planned Hours>1,"(1h-3h]","[0-1h]")))any help will
Hi All - I have a custom number field that shows "Number of assets
requested" by project. I want to show the TOTAL number of assets
requested for all projects in that portfolio. Can I create a calculated
field to show that number? Thank you! Olivia
Hi! Is it possible to Concat a checkbox field with a free text field? We
have a checkbox option that displays "Other" as an option and we allow
our users to type in names of people they need for route reviews on
projects. I am trying to bring together the checkbox field and free text
field to stream...
I am just starting of working with calculated fields so I am still
trying to figure this out. I have done a lot of digging on this site to
see if I can find the answers I'm looking for but I can't come up with
the right custom expression I am looking for. Here is what I am trying
to do. I would like...
Is it possible to use the Custom Dates in a calendar to report up a
level. Example: I'm filterign by tasks but I want to use the Custom Date
to pull a field at the Project Custom Form level. Related - can I used
calculated fields on a task form to pull info from project-level cutsom
fields? In worki...
I have a project-level custom field with a calculation that had to be
recalculated across our entire instance, but seems to not have refreshed
on a handful of specific projects. Is there a way to force a
recalculation of this field for a specific project?
I have a request for getting the elapsed time from when an Issue is
submitted (in a stand-alone request queue project) to when it was
converted to a project or task (in a separate project from the Issue).
So the first trick was getting the start date that the Issue was
accepted and converted, which ...
I'm looking to see if this can be solved by a calculated field. Jennifer
Smith in her profile can either be Copywriter or Quality Analyst on any
given project. Is there a way to create a calculated field on a project
form that pulls in whomever is assigned the role Copywriter to a
project? (When I p...
The radio button options contain reoccurring words (e.g. North, South).
I'd like to report and group with the option's remain words (e.g. Dade,
Broward). Perhaps it'll require a calculated field and a calculated
column. I've tired many variations similar to: IF(CONTAINS(Region,“North
Hello! We have a calculated field in our instance to calculate a job
number ID that a team uses within their process - the field as it is
programmed is: CONCAT(YEAR(Planned Start Date),IF(MONTH(Planned Start
Date)<"10",CONCAT("0",MONTH(Planned Start Date)),MONTH(Planned Start