;

Skip to main content

 

  • arrow icon
Language Selector

  1. Other Languages

    (machine translation)

 

Planview Customer Success Center

ToString Function

  1. Last updated
  2. Save as PDF

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()