Skip to content

Formula (Extended): $RAND Function

Overview

Return a random real number greater than or equal to 0 and less than 1. Return a new random number each time it is calculated.

Syntax

$RAND()  

Parameters

None

Return Value

Real number greater than or equal to 0 and less than 1

Return Value Display Content

Target Display Content of Return Value
Classification (including title, status, manager, owner) Display return value.
Numerical Value (including work volume, progression rate, remaining work volume) Display return value.
Date (including start and completion) Do not display.
Description (including content) Displays return value.
Check (including lock) Do not display.

Usage Example ①

Specify parameters by screen column name (name displayed)

Formula

Formula using the $RAND function in usage example 1

Calculation Result

*Change each time.
Calculation result of usage example 1 of the $RAND function

Usage Example ②

Combination with other functions

Formula

Formula using the $RAND function in usage example 2

Calculation Result

*Change each time.
Calculation result of usage example 2 of the $RAND function