Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
SEQUENCE

SEQUENCE

Description

Creates an array of sequential values, such as a numbers or a series of dates. This function can be helpful when creating dynamic models. Example: You are creating an ad hoc forecasting model and you want to create a dynamic sequence of dates based on time and not based on the live data in the workbook.

Syntax

SEQUENCE(
rows
, [
columns
], [
start
], [
step
])
  • rows
    : An integer for the number of rows to return.
  • columns
    : An integer for the number of columns to return.
  • start
    : The starting number for the sequence.
  • step
    : The number to increase each value by. Example: When
    start
     is for date values, a
    step
     value of 7 increments a date series in weekly (7 day) increments.

Example

To download working examples of the SEQUENCE function in a workbook, see https://collaborate.workday.com/t5/-/-/m-p/910596 .

This content is not part of the Workday Administrator Guide.