Thanks for helping out, @AndyKent. I gave this a shot and it's giving me N/A. Here's the full formula:IF(LEN({NAME}) <10, "Over 10", "Less 10") FYI,LEN({NAME}) - This works
Hey @AndyKent, this is a good workaround. Is it possible to add an IF statement into the LEN function?For example, if LEN > 10, add text "Too long". If LEN < 4, add text "Too short".
Hey @lgaertner, appreciate the response. See below for the text mode of the 4 empty fields. Empty field 1 - Tactic: Campaign Namedisplayname=linkedname=projectnamekey=view.relatedcolumnnamekeyargkey.0=projectnamekeyargkey.1=Campaign Namequerysort=DE:project:Campaign Namevaluefield=project:Campaign N...
Hey @MoniqueEvans, appreciate the response. I'm pulling from the Expense report and that report doesn't have Program or Portfolio. Is there a workaround for this?
Why does Workfront Report shows no value when there is data in the field? Campaign and Portfolio field are the standard field in Workfront and not a custom field. Screenshot shows the values in the Tactic/Project. I've tried mutiple fields but all of them came up blank. What am I doing wrong?
@lgaertner @KellieGardner Thanks for the response, guys.I had a look again and the remaining cost is a Project-level field and it is calculating the remaining based on all the expenses in that Project.
Hi,I believe the Remaining Amount column in Expenses in incorrect or am I missing something in its calculation?Invoice Date 2024:Planned Amount: $800Actual Amount: $600Remaining Amount: $1000? It should be $200 Invoice Date 2023:Planned Amount: $16000Actual Amount: $13200Remaining Amount: $5000? It ...