Formula

Explore Layer's formula capabilities for date, text, and math functions. Learn how to use DATE, CONCATENATE, ROUND, and more to enhance your data calculations.

Zach Soflin

Sep 24, 2024

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