Hi,   I would use a set variable module and utilise use the add function. The syntax for the add function is:   add(array;value 1;value 2)   So in your example it would look something like:   add(DE:Assets Inventory - Antenna;DE:Assets Inventory - Baseband)   Best Regards, Rich.    

Hi,   You first need to create the field with no calculation. Then save and close form (this will commit the newly created field to Workfront’s database). Then reopen the form and add the calculation.  Best Regards, Rich

Hi Megan,   The following text mode view would display all groups a user belongs to, regardless if the group is primary or secondary:   displayname=All Groups listdelimiter=<br> listmethod=nested(userGroups).lists textmode=true type=iterate valuefield=group:name valueformat=HTML   Best Regards, Rich...

Hi,   Yep, the actual completion date of a project will change each time the project is set to complete. The way to work around this is to create a calculated field on a project custom form, that will capture a timestamp of when the project was first set to complete. This date will remain "locked" s...

Hi,   There's a couple of approaches you could take here. . .   Natively Workfront will capture the assignment/reassignment of tasks as a journal entry (if you view the system activity on a task, details of assignments are logged here). Therefore, a journal entry report might be enough to get what y...

Hi,   Try the following instead:   {enteredBy}.{name}   Best Regards, Rich.  

Hi,   Unfortunately Workfront does not have the ability to build field choice logic (i.e., dynamically display values in one field based on the values chosen in another field) the same way that you can build field display logic.   The way to achieve this would be to use an External Look up field and...

Apologies, just re-read your question. You would like to count words, not characters.   Using the following text mode in a calculation would get you a lot closer:     SUM(1,SUB(LEN(REPLACE({DE:Name of Field To Count}," ","**")),LEN({DE:Name of Field To Count})))     What this calclulation is doing i...

Hi,   Unfortunately there is no functionality to limit the number of characters in a text field and prevent users from typing over that limit.   What you could do however, is build a calculated field that counts the number of characters used and then returns a value of "over character limit" (or any...

Yes, it should work with a formatted text field. However, it probably wont record changes to formatting, on changes to the text values.   The other consideration is how many updates are made. Every change to the field will generate a record in the updates feed, if there are lots of changes you will ...