Is there a way to create a link that goes to a specific view? I need to be able to get to a task view report with a certain view. I'd like to either go from a text mode column or a project level shortcut. Byron Nash INSP, LLC.

It appears to be a limitation of the syntax according to support. Does anyone have any workarounds for this sort of thing? Byron Nash INSP, LLC.

Thanks, I submitted a ticket. Byron Nash INSP, LLC.

The REPLACE() function seems to behave normally. Until you try to replace a " "(space) with a ""(no space). It doesn't like the no space thing. How do I remove all the spaces from a string? I can put in about any other character but not "no space". Byron Nash INSP, LLC.

Here's my code. IF({project}.{DE:Program Type}="Acquired Movies",{project}.{DE:Acquired Movies}, IF({project}.{DE:Program Type}="Acquired Series",{project}.{DE:Acquired Series}, IF({project}.{DE:Program Type}="Events",{project}.{DE:Events}, IF({project}.{DE:Program Type}="Blocks",{project}.{DE:Block...

I would like to pull data into one column based on what is chosen in the previous column. Column "A" contains a list. Each item in that list represents another list. I'd like the field for the child list to be displayed in column "B". I'm trying IF statements but the text editor is getting really sl...

Awesome, yes I'm getting there. This info is not obvious in the docs! How do you go between the two values of a field at will? Let's say I wanted to CONCAT some values based on the hidden value and some based on the visible one? Byron Nash INSP, LLC.

I am working with a View on a Task Report. I'm trying to pull together various values from a mix of Task and Project level custom fields. In the end, I'd like to CONCAT them together into one string that I can use in my pipeline as a filename or project name. Promo Type is a Project level custom fie...

Next problem: I'm trying to pull a piece of data from the project. It's returning something but not the right thing. I'm getting the entire project name instead of the "Promo Type". What am I doing wrong now? displayname=ProjectNameCustom textmode=true valueexpression=CONCAT({DE:project:Promo Type},...

Thanks! I bet it was the DE. I'm sure I'll have more questions later but this helps a lot! Byron Nash INSP, LLC.