I'm probably going to make a hash of trying to explain the EXISTS FILTER but here it is, explained as I understand it. You have to be able to know how to read the API EXPLORER a bit before trying this: PROBLEM: Show me projects where portfolio owner is no longer active in a PROJECT report. SOLUTION:...
Hi Kirsten, One thing I can think of is that you could create a custom column in text mode that limits the length of the strings. Then, to Narayan's point, have a view that allows you to edit the fields versus view these limited strings. Think: SUBSTR({string},number of start position, length of str...
I'm sure I'm not alone here but my designers are having a very hard time navigating Home and feeling confident that they know what they need to get done each day. I heard a few people at LEAP mention that they created a hot sheet/daily report that tells their designers what they need to work on and ...
Is there a way to enable a spell-check type of view from within a proof? The backstory is - yes, this should be done in the native file (InDesign, Word, etc) but - whatever the reason, we are often battling spelling errors that make it into proofing. It'd be great if proofers had a spell-check aid w...
Does anyone know how to do a If/Then statement in the reporting. My tasks have a custom notes field and I only want to show the notes at the parent task level, below is how this would look: If parent is a project (identifying top level tasks) Show task note If parent is a task Show parent ta...
I would like some of our non-deadline project schedules to automatically update the timeline based on actual completion dates of predecessor tasks without me having to redo a schedule for every delay. Is that possible? I've been looking into task duration, constraint types, etc, but don't understand...
I want to update my project status reports to include the task name and all assignees (not just primary) for all the tasks that are currently in progress.I found the text mode for the task collection but I'm having trouble modifying the expression to an "IF statement" so that it only shows if the st...
Hi All I have been looking at improving one of our project reports to contain some additional information from the issue that was used to create the particular project. What I was hoping to be able to do is to show the date the issue ticket was closed. The reason for this is that if any of our proje...
We are experiencing issues with notifications and the new @mentioning people who are not on the proof functionality: If a user who is not the proof owner or user who does not have supervisor permissions tags a person who was not originally on the proof, that person never receives an email notifica...
I have been playing around with task constraints and duration types for our staffing needs. It seems like effort driven works well in the sense that I put in the planned start date and the planned completion date and it calculates the planned hours. We only assign 1 resource per task. So if I wanted...