Returns the largest integer less than or equal to the number.

floor · Notion Formulas · Ben Smith

Ben Smith · Digital Designer & Notion Expert

toNumber · Notion Formulas · Ben Smith

Checks if the first value is less than the second.

< · Notion Formulas · Ben Smith

- · Notion Formulas · Ben Smith

Examples for questions found on the internet.

Notion Examples · Ben Smith

Formats the date using a custom format string.

formatDate · Notion Formulas · Ben Smith

+ · Notion Formulas · Ben Smith

Returns the first value if the condition is true; otherwise, returns the second value.

if · Notion Formulas · Ben Smith

Checks if the first value is greater than the second.

> · Notion Formulas · Ben Smith

Where

Type

Column

super:Link

Related to Notion Formulas (1) (Examples Used In) 1

Related to Notion Formulas (Examples Used In)

Direct Link

Convert to Example

Date

Related to Notion Formulas (1) (Examples Used In)

Description

Website

Contact Email

Contact Phone

Is Active

Owner

Attachments

Priority

Due Date

From

Updated

Formulas

Created

Example

To-do

In progress

Complete

Status

Share

End Date

formatDate

Start Day #

Start Date

subtract

Start - End

equal

Correct

larger

unaryMinus

Start Day - End Day > 1

Subtract Weekends

Remove End Day

Weekdays Between

End Day #

Sun to Sat

smaller

toNumber

ceil

Days Between

Desired Result

Remove Start Day

Name

By Date Updated

By Date Created

Calendar

Broken

By Status

Gallery

Needs Work

Archived

Default View

Examples being updated from Formulas 1.0 to 2.0

Updating

Weekdays Between → Separate Calculations