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