Not sure if this is bad syntax or not a possible filter?  All I know is this throws an error.  Expert advice needed! I'm obviously not an API explorer expert but it looks like I should be able to access the field.  project:status=CURproject:status_Mod=inDE:Key Date=YesDE:Key Date_Mod=inproject:conve...

I am trying to build a task report to show tasks with a particular custom field but using the user wildcard to only display projects in which the user is the OpTaskOriginator.  I attempted the below using the API explorer and references across tables, but am getting an error.  Did I make a mistake i...

I am trying to create a column on a project report to display tasks (and due dates) with a certain custom form field applied.  Loading the tasks and due dates themselves is easy enough, but I also want to filter out tasks that are already complete so the viewer will only see what is in the future by...

Description -Why is this feature important to you - Our data engineering team is working to leverage system data using the API but cannot access everything they need without running reports.How would you like the feature to work - Same as all the other data.  Accessible via API call.Current Behaviou...

I am trying to put together an Issue report that includes a column to calculate actual hours logged to both the issue and the resolve project.  This is just to add the values from both actual hours columns in the image below (which do have values) and not even to sum at the grouping level, but the c...

I am trying to add a column to a project report to calculate the number of issues on the project that contain the words Change Order.  So far, I can't get anything to return.  Any thoughts on where I'm going wrong with this? valueexpression=SUM(IF(CONTAINS('Change Order',{OPTASK}.{name})=true))

Description - We would like to see another "access" level that would enable us to assign rooms and equipment like users and track the hours those resources are utilized as part of projects.  Why is this feature important to you - Our organization has studios and editing suites that leadership has a...

I am trying to create what I thought was a simple nested IF statement calculation to populate one choice if one or more options of a multi-select field are selected, another is displayed if different options are selected and both are displayed if there is overlap.  The quick example I started with i...

I have been able to get a percentage calculation by dividing the values in the hours column by 35 in the Utilization Percentage column, but would like to add all those up to get a total percentage.  I'm relatively new to text mode and tried to Frankenstein things together from other columns.  Does a...

Is there a way to report on documents that are linked via cloud providers rather than uploaded to the documents area of a project?