Formulas4Notion-Notion Formula Expertise

Example

let(today, now(), let(startOfWeek, dateSubtract(today, day(today), 'days'), let(endOfWeek, dateAdd(startOfWeek, 6, 'days'), if(prop('Status') != 'Done', and(dateBetween(prop('Deadline'), startOfWeek, 'days') >= 0, dateBetween(prop('Deadline'), endOfWeek, 'days') <= 0), false))))

Scenario

This function is used in scenarios like project management databases to identify tasks whose deadlines fall within the current week.

Example

concat('Task: ', prop('Title'))

Scenario

Useful for creating customized titles or descriptions in content management systems, where a prefix or suffix needs to be added to existing text.

Example

prop('Checkbox') ? 'Complete' : 'Incomplete'

Scenario

Applied in task tracking databases for changing the status display based on the completion status represented by a checkbox.

Example

prop('Price') * prop('Quantity')

Scenario

Used in inventory or sales databases to calculate total cost based on unit price and quantity.