Notion4 min read
Your Notion relation formula is blank
A blank relation formula is usually no access, a missing .first(), or an empty related page. Check those before blaming Notion.
Shashwat TalwarTopic archive
Notion Formula
Practical Notion ideas, workflows and inspiration collected in one place.
Latest in Notion Formula
Updated as new posts arriveShashwat Talwar
Notion5 min read
Formula depth limit reached: your syntax is fine
Formula depth limit reached means the chain is 15 layers deep. Each formula or rollup reference adds a layer, even in another database.
Shashwat Talwar
Notion5 min read
Don't paste that AI Notion formula
Notion AI can write the formula. Turn on Show types, then check date order, empty(), and lists before you save.
Shashwat Talwar
Notion5 min read
The quotes that break your Notion automation
A pair of quotes is text, not a blank date. Use empty() or a Notion formula automation will not save.
Shashwat Talwar
Notion7 min read
Why your Notion days left formula is negative
dateBetween() subtracts the second date from the first. Swap them and days left goes negative. Guard a blank date before you call it.
Shashwat Talwar
Notion4 min read
Your Notion rollup is not a number (and how to do math on it)
A rollup showing 1892 or 35% can still be a list. Why multiplication and dateAdd throw a type error, and the three fixes that work.
Shashwat Talwar
Notion4 min read
Your Notion formula returns a list, not text
People, relation and multi-select properties return lists in Formulas 2.0. Why deleting Notion's .map().join() quietly breaks filters.
Shashwat Talwar
Notion9 min read
How to show Due today, Due tomorrow and Overdue in Notion formulas
Build Overdue, Due today and Due tomorrow labels in Notion with dateBetween, dateStart, ifs and style — and fix the off-by-one day.
Shashwat Talwar
Notion6 min read
Logic functions in Notion formulas!
Learn about Logic functions, explore Boolean logic operations & discover how to use them in Notion formulas!
Shashwat Talwar
Notion6 min read
What are the operators in Notion - A Complete Guide
Operators are a powerful feature in Notion that allow you to perform various actions and calculations. They enable you to manipulate and analyze data…
Sanat | Theaccountantguy (Finance Guy)
Notion3 min read
How to add text to a formula in Notion?
Learn how to add text to a formula in Notion using functions. This step-by-step guide will help you create more informative and user-friendly formulas in…
Shashwat Talwar
Notion4 min read
Text Functions in Notion formulas! (Part Two)
Discover how to manipulate & extract information from text entries in Notion databases using text functions & formulas.
Shashwat Talwar
Notion3 min read
Text functions in Notion formulas!
Learn how to use Notion formulas to manipulate and extract information from text entries with the help of text functions!
Shashwat Talwar
Notion4 min read
Mastering Date and Time Functions in Notion Formulas - Part Two!
Discover the ins and outs of Date & Time functions in Notion formulas! From extracting date components to timestamps!
Shashwat Talwar
Notion6 min read
Mastering Date and Time Functions in Notion Formulas!
Learn all about Date & Time functions in Notion formulas! From extraction date components to converting timestamps!
Shashwat Talwar
Notion4 min read
Basic mathematical operators in Notion formulas - Part Two
Discover the powerful capabilities of formulas in Notion and transform your workspace into an organized and streamlined system.
Shashwat Talwar
Notion5 min read
Basic mathematical operators in Notion formulas
Master the essential Notion functions for performing calculations using basic mathematical operators!
Shashwat Talwar
How To2 min read
How to auto change tag based on value of another property?
Follow these few simple steps to learn how to use formula to change Tags automatically with another Property!
Shashwat Talwar