Skip to main content

 

Planview Customer Success Center

Min Function

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