WF Support also provided this option using SUBSTR which works as well: displayname=Phone Numbervalueexpression=IF(ISBLANK({phoneNumber}),"",CONCAT("(",LEFT({phoneNumber},3),") ",SUBSTR({phoneNumber},3,6),"-",RIGHT({phoneNumber},4)))valuefield=phoneNumbervalueformat=HTML

That worked perfectly! Thank you!

I'd like to have a user's phone number format as (xxx) xxx-xxxx in a report.I tried the suggested text mode below, but it returns only 7 out of 10 numbers. it's missing the middle three numbers.valueformat=HTMLtextmode=truevaluefield=phoneNumbervalueexpression=IF(ISBLANK({phoneNumber}),"",CONCAT("("...

Thank you for those ideas! If I end up using one, I'll mark your answer as Correct.

Anyone know how to report on the dates that a user volunteers to work on a task? Specifically, when a user clicks "Work on it" from the task window of a task that is assigned to a team. I'm trying to show how many tasks a user volunteers for each week.  In the system activity log, the post says "Chr...

Thank you! This worked beautifully!

I'm looking to filter an issue report by issues pending approval by my team. "My team" could be my Home Team or one of my Other Teams.  Any help would be appreciated!

I need to be able to group and bar chart a task report by the current task's predecessor's parent name. I've created columns on the task report that show the correct results using this text mode: Predecessor name: displayname=Preceding Tasklistdelimiter=listmethod=nested(predecessors).liststype=iter...

Clever! I'll definitely try that. Thank you!

We need this too. Our content reviewers sometimes need to send an asset to legal for their input. Legal adds comments, then makes a decision. Then, it needs to go back to the content reviewer to fix anything that legal identified before approving the asset for design.