Skip to main content

 

Planview Customer Success Center

ToString Function

ToString (value as Object, format as String) as String

Category: Convert
Description: Converts any value to a string
Supported Context: FormulaField And BusinessRules
Parameters:  
value as Object Represents a numeric or pick list value, or reference to a field that will return a numeric or pick list value
format as String  
Returned value as String Returns a text or string value equal to the value entered in the "value" parameter
Example #1

Create a formula field on work items that returns a string representing the Due Date in the format of YYYY-MM-DD HH:MM:SS

ToString($DueDate)

Example #2

Create a formula field that is set on work items that will return the system ID of the 'Parent Project' (e.g."P-1")

ToString($ParentProject)

Tips
  • To prevent run time errors, use the Catch() exception
  • To convert picklist values to strings for formula calculations use ToString($PicklistField)
Related Functions

Catch()