Formula Fields

A comprehensive list of supported functions available to use in Layer's formula field

Silvia Lee avatar
Written by Silvia Lee
Updated over a week ago

For a full list of available formulas: https://formulajs.info/functions/

DATE

DATE(year, month, day)

  • year - The year component of the date.

  • month - The month component of the date.

  • day - The day component of the date.

DATEVALUE(date_string)

  • date_string - The string representing the date.

DAY(date)

  • date - The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.

DAYS(end_date, start_date)

  • date - The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.

TEXT

CONCATENATE('text', ' ' , 'text')

  • Click values on the left to include in the formula

  • Text to be included must be placed between ' '

  • Use commas to separate each item

MATH

ROUND(value, 2)

  • value - the number you want to round (numbers only, cannot use text fields)

  • 2 - the number of decimal places you want to round to

Did this answer your question?