<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> The example database below demonstrates how you can group a database view by the output values of a formula.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Clients

“Next Check-In” Property

dateAdd(prop("Last Check-In"), 3, "months")

“Next 7 Days” Property

// Compressed
if(dateBetween(prop("Next Check-In"), now(), "days") < 8, "Next 7 Days", "More than 7 Days Out")

// Expanded
if(
    dateBetween(
        prop("Next Check-In"), 
        now(), 
        "days"
    ) < 8, 
    "Next 7 Days", 
    "More than 7 Days Out"
)

© Thomas Frank