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

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

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

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

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

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

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

Glad it worked! I'm happy to help.

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

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