;

Skip to main content

 

  • arrow icon
Language Selector

  1. Other Languages

    (machine translation)

 

Planview Customer Success Center

Min Function

  1. Last updated
  2. Save as PDF

Min (arg1 as Object, arg2 as Object, ... as Object) as Object

Category: Math
Description: Returns the smallest value of the arguments
Supported Context: FormulaField And BusinessRules
Parameters:  
arg1 as Object Represents any value type, or reference to a field that will be compared to the other "arg" parameters
arg2 as Object Represents any value type, or reference to a field that will be compared to the other "arg" parameters
... as Object Represents any value type, or reference to a field that will be compared to the other "arg" parameters
Returned value as Object Returns the minimum value of the values provided in the "argx" parameters
Example #1

Create a validation rule that will check whether a work item's start date was updated by setting the work item 'Duration', and begins prior to the parent milestone or project's start date. In such a case, throw an error and block updating the appropriate duration of the work item.

The Evaluation Criteria of this validation rule will be:

IsChanged($Duration) && IsChanged ($StartDate) && Not (IsNULL($Milestone)) && (Min($StartDate, $Milestone.StartDate, $Project.StartDate) = $StartDate)
Tips Validation Rules can be used throughout the entire system and will help in regulating data as per your organizational standards