I am trying to create a calculated field for a series of Tasks. If the Task name Contains the number "1" I need it to display a date from the Project custom form.I was able to return a True/False result using CONTAINS and I have been able to display the date without a condition but when combining th...
I have a report already filtered by specific project criteria and in a column of the report, I'd like to list the name of any documents in a specific folder within that project.I can get a list of names of documents using below code, but it doesn't seem to pull in document description or folderIDs w...
I'm looking to setup two tasks -- one for "Meeting" and another for "Schedule Meeting". I'd like the "Schedule Meeting" one to dynamically start 2 weeks prior to the "Meeting" task, which has other dependencies on the rest of the project.I've tried a number of different options related to both pred...
I am trying to create a project view that will display the selections made in two dropdown fields in the custom form. I have no problem with the first column, but the second column is a problem. I'm hoping this is something that can be solved with text mode, but my text mode knowledge is extremely l...
Hi, I've received a couple reports from my user base letting me know that they are unable to see any custom data on reports. The data is visible to them on the custom form but when in a report they cannot see the values. I'm an admin and can see the values but when I log in as them, I experience t...
I want to know the list of Layout templates available in the system and its assignments to see if there are any Job roles assigned to them.Can someone please help me how to achieve in Text mode column? Thanks in advance!
Hi all! I'm working on a project report, and have added a column with the following text mode code:displayname=People listdelimiter=<div> listmethod=nested(projectUsers).lists type=iterate valueexpression=CONCAT("• ",{user}.{role}," — ",{user}.{name}) valueformat=HTMLI've used this basic setup in ot...
Hi,I am looking for a (text mode) option to sort a field that includes dates and times, but is a text field: June 1 - 8:00June 1 - 9:00June 2 - 8:00June 2 - 9:00 Is there a way? Thanks in advance
We have a meeting every week to discuss new photo and video projects with our studio team. We'd like use a WF report to automate creation of the agenda. I have a report that filters the requests and shows the needed data. I'd like to add a timeslot as a column in the report. The first request enter...
Hi Community,We have a request queue with a calculated field adding certain capacity points for certain requests:1. Creating New content for Sprint x has 2 points2. Updating existing content for Sprint x has 1 point3. Re-using existing content for Sprint x has 0 points.How do I set up a calculated f...