Expandir minha barra de realizações na Comunidade.

Tipo
  • Todos
  • Perguntas
  • Debates
  • Ideias
  • Blogs
Filtrar por contribuições do usuário
  •  no Workfront Questions 16/10/2018
    Hi Catherine, Maybe you could come about it a slightly different way: actualCompletionDate=FIELD:plannedCompletionDate actualCompletionDate_Mod=gt This doesn't allow you any granular control like daysLate=5 would (as an example), but I think it may get rid of your zeros...haven't thoroughly tested, ...

    Tipo

    Perguntas

    Visualizações

    1.2K

    Curtida

    0

    respostas

    0
  •  no Workfront Questions 04/10/2018
    Hi Stephanie, I think you're on the right track, but you might try this instead: displayname=HrMin textmode=true valueexpression=CONCAT(FLOOR({actualWorkRequired}/60)," Hours ",SUB({actualWorkRequired},PROD(FLOOR({actualWorkRequired}/60),60))," Minutes") valueformat=HTML (Sigh...where's a good Excel...

    Tipo

    Perguntas

    Visualizações

    684

    Curtida

    0

    respostas

    0
  •  no Workfront Questions 27/04/2018
    Hi Tim, Adding to what Doug and Melinda have said, it's also worth mentioning there are subtle differences between syntax on custom fields (the ones you set up on a custom form) vs calculated fields in reports. If I'm interpreting correctly, I think you are working on a calculated field in a report?...

    Tipo

    Perguntas

    Visualizações

    921

    Curtida

    0

    respostas

    0
  •  no Workfront Questions 25/04/2018
    Hi Susan, This isn't the least bit elegant, and the performance would probably be unpleasant in a large report, but if you're desperate, I believe the following will work. In a quick test I did where I exported a decent subset of data and compared the results against those of WEEKNUM, everything mat...

    Tipo

    Perguntas

    Visualizações

    1.8K

    Curtida

    0

    respostas

    1
  •  no Workfront Questions 26/02/2018
    Actually, I think the reason for mine being blank is much simpler. User error! I used Notepad to compile most of my formula (minus listdelimiter), waiting until I popped it in the report to look up the proper delimiter on my cheat sheet. Unfortunately, I copied and pasted from the incomplete one whe...

    Tipo

    Perguntas

    Visualizações

    2.4K

    Curtida

    0

    respostas

    0
  •  no Workfront Questions 19/02/2018
    There are ways to do this, but the result will depend rather substantially on how your projects are structured. You may end up with more than one active milestone based on your dependencies and where your milestones are applied. If you want to show one line per project, create a project report and a...

    Tipo

    Perguntas

    Visualizações

    2.4K

    Curtida

    0

    respostas

    0
  •  no Workfront Questions 22/08/2017
    Hi Molly! Sorry your question was overlooked! If I'm understanding what you're requesting, yes this is possible; it just takes a quick jump in and out of text mode to get it to work. I'll get you started with a task report as an example. In your filter window, you want to end up with something that ...

    Tipo

    Perguntas

    Visualizações

    529

    Curtida

    0

    respostas

    0
  •  no Workfront Questions 23/06/2017
    Glad it worked! I'm happy to help.

    Tipo

    Perguntas

    Visualizações

    1.5K

    Curtida

    0

    respostas

    0
  •  no Workfront Questions 21/06/2017
    Hi Ondina, With that being the case, I think your best bet is to return to SUBSTR. The following calculation checks to see if there is a “?” in {field} and if so, it will return just the portion between the “.com/” and the “?”. If not, it will just return anythi...

    Tipo

    Perguntas

    Visualizações

    1.5K

    Curtida

    0

    respostas

    0
  •  no Workfront Questions 20/06/2017
    I’m so glad that helped! And I think you have it! Since we need to tell the RIGHT function, the exact number of characters we want to return from the right of {field}, we first need to figure out the entire length of {field} (since that could be anything). Then we subtract out everything prior...

    Tipo

    Perguntas

    Visualizações

    1.5K

    Curtida

    0

    respostas

    0
Principais medalhas conquistadas por KathyLe1
Personalize as medalhas que deseja mostrar no seu perfil