<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 lists bank account balances. The sign() function is used to determine the output of the Status property.

• Full Reference

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

</aside>

Bank Balances

// Compressed
sign(prop("Balance")) == -1 ? "🔴 Negative Balance!" : sign(prop("Balance")) == 0 ? "🟡 $0 Balance" : "🟢 Balance OK"

// Expanded
sign(
    prop("Balance")
) == -1 ? 
"🔴 Negative Balance!" : 
sign(
    prop("Balance")
) == 0 ? 
"🟡 $0 Balance" : 
"🟢 Balance OK"

• More Formula Examples

© Thomas Frank