Ben SmithBen Smith
Ben Smith/
if
if
if

if

Category
Conditional
Accepts
Boolean
Returns
All Data Types
Alternative
? :
? :
More
The
? :
? : version is called the ternary operator.
Examples Used In
Bill Overdue
Bill Overdue
Colour-based Relations
Colour-based Relations
Count Multi-Select
Count Multi-Select
Date Wrong
Date Wrong
Days Until
Days Until
Due Soon
Due Soon
Grade Calculator
Grade Calculator
Incomplete Tasks
Incomplete Tasks
🔢
Increment
Last Interaction Flag
Last Interaction Flag
Minutes Until
Minutes Until
On Hold
On Hold
Polls
Polls
Priority Tags
Priority Tags
Products & Materials
Products & Materials
Progress Bar (Old)
Progress Bar (Old)
Progress Property
Progress Property
Project Period
Project Period
Related Due Dates
Related Due Dates
Shopping List
Shopping List
Show/Hide
Show/Hide
Status Icons
Status Icons
Weight Tracking
Weight Tracking
Formula Filter
Formula Filter
Statuses
Statuses
This Week *
This Week *
Validate Status
Validate Status
Time to Revise
Time to Revise
Task Statuses
Task Statuses
Weekly Dates
Weekly Dates
Reading Wishlist
Reading Wishlist
Days Left & Priority Formulas
Days Left & Priority Formulas
Simple Status
Simple Status
Language Check
Language Check
Last Appointment
Last Appointment
Days Between *
Days Between *
Bonus Amount
Bonus Amount
Relative Dates
Relative Dates
Progress Bar
Progress Bar
Past/Today
Past/Today
Deadline Status
Deadline Status
Add Percentage
Add Percentage
Earliest Date
Earliest Date
Unique IDs
Unique IDs
Simplified Progress Bar
Simplified Progress Bar
Panels & Modules
Panels & Modules
Combined Totals
Combined Totals
Maintenance
Maintenance
Days Ago/Left/Away
Days Ago/Left/Away
College
College
Social Media Planner
Social Media Planner
Float
Float
Count Business Days
Count Business Days
Calendar Due Date
Calendar Due Date
Weighted Tasks
Weighted Tasks
Form Rating
Form Rating
Time Check
Time Check
Active if Approved
Active if Approved
Date Range Formatting
Date Range Formatting
Due Date Statuses
Due Date Statuses
Days On Read
Days On Read
Weekly Filtering
Weekly Filtering
Checkbox Progress
Checkbox Progress
Split Text at Character
Split Text at Character
Latest Date
Latest Date
Days Left
Days Left
Days Elapsed
Days Elapsed
Word Count
Word Count
🚗
Distance Difference
Day Colours
Day Colours
Eat the Frog
Eat the Frog
Due Date
Due Date
Projects & Teams
Projects & Teams
Expiry Dates
Expiry Dates
Time to Reach Out
Time to Reach Out
Due Date from Terms
Due Date from Terms
Days Working
Days Working
Next Weekday
Next Weekday
Recur Every D/W/M/Q/Y
Recur Every D/W/M/Q/Y
Task Completion
Task Completion
Cooking Calendar
Cooking Calendar
HH:MM:SS to Minutes
HH:MM:SS to Minutes
Household Tasks
Household Tasks
Percent of Text Filled
Percent of Text Filled
Steps
Steps
Birthdays
Birthdays
Count Decimal Places
Count Decimal Places
Remove Due Date
Remove Due Date
Percent Complete
Percent Complete
Net Profit
Net Profit
Overtime
Overtime
This Week *
This Week *
Action Progress
Action Progress
Eisenhower Matrix
Eisenhower Matrix
On This Day
On This Day
Y, M, & D Between
Y, M, & D Between
QC Rate
QC Rate
Driving Time
Driving Time
Main Contact
Main Contact
Citations
Citations
Mile Pace
Mile Pace
Time Calculator
Time Calculator
Countdown
Countdown
Combine Relation Properties
Combine Relation Properties
Last Day of Month
Last Day of Month
Add Prefix
Add Prefix
Star Signs
Star Signs
Age in Years & Months
Age in Years & Months
Filter by Time of Day
Filter by Time of Day
Due State
Due State
Weekly Focus
Weekly Focus
Caloric Difference
Caloric Difference
Weight Conversion
Weight Conversion
Percentage Increase/Decrease
Percentage Increase/Decrease
Next Actions
Next Actions
Fiscal Year
Fiscal Year
Follower Goals
Follower Goals
Game Scores
Game Scores
Due In
Due In
Within 7 Days
Within 7 Days
Date Tests
Date Tests
Tagged Events
Tagged Events
Contains Current Day or Date
Contains Current Day or Date
Coloured Progress
Coloured Progress
Different Salaries
Different Salaries
Goal Progress
Goal Progress
Book Planner
Book Planner
Meetings
Meetings
Multiple Progress Bars
Multiple Progress Bars
Budget Remaining
Budget Remaining
Location from Time
Location from Time
YouTube Thumbnail URL
YouTube Thumbnail URL
Due Date Status
Due Date Status
Average Percentage
Average Percentage
Course Date Progress
Course Date Progress
Date & Time Status
Date & Time Status
UTM Link Generator
UTM Link Generator
Isolate Names
Isolate Names
Manipulating Articles ('The', etc.)
Manipulating Articles ('The', etc.)
Age from Date of Birth & Death
Age from Date of Birth & Death
Time of Day
Time of Day
Prioritisation Matrix
Prioritisation Matrix
Total Hours
Total Hours
Priority Level
Priority Level
Progress Between Dates
Progress Between Dates
Tuition Calculator
Tuition Calculator
Gauge Chart
Gauge Chart
Do/Due Date
Do/Due Date
Risk Assessment
Risk Assessment
Ranking Bar
Ranking Bar
Rainbow Progress Bar
Rainbow Progress Bar
Current Date as End Date
Current Date as End Date
Replace Tags with Emojis
Replace Tags with Emojis
Weekly & Monthly Review
Weekly & Monthly Review
Metres to Miles
Metres to Miles
Templates Used In
Recipe Book
Recipe Book
Common Uses
New in 2.0
Share Link
https://notion.cool/formulas/if
Companion Docs
https://www.bensomething.com/notion/formulas/functions/if
 
Syntax
if(boolean, value, value)
boolean.if(value, value)
Examples
if(true, 1, 2)
false.if(1, 2)
 
 
More Info
if · Notion Formulas · Ben Smith
Returns the first value if the condition is true; otherwise, returns the second value.
if · Notion Formulas · Ben Smithif · Notion Formulas · Ben Smith
https://www.bensomething.com/notion/formulas/functions/if
if · Notion Formulas · Ben Smithif · Notion Formulas · Ben Smith
MainMainif · Notion Formulas · Ben Smith
if · Notion Formulas · Ben Smith

if · Notion Formulas · Ben Smith

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

MainMain