- Formula

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

The Layer team is currently developing improvements to the formula field releasing Spring 25. Here is a list of the functions that will be available then. https://app.layer.team/functions