You're my hero @skyehansen!

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...

Thank you, Skye.  You have pulled my sanity back from the edge. I appreciate your help.

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...

Thank you, Katherine!  I forgot about that syntax entirely. Much appreciated!

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...