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
Databases
Practical Notion ideas, workflows and inspiration collected in one place.
Latest in Databases
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
How To2 min read
How To Show Sub-Task's Completion in Percentage?
🚀 Track your completed daily tasks in Notion easily in the form of percentage to stay motivated towards your goals!
Shashwat Talwar
Notion2 min read
How to create subtasks in notion
In this blog you will be reading about how you can create sub tasks in your databases. Follow the steps below to create sub tasks:-
Tushar
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
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
How To1 min read
How to make 2 same databases sync together? 🔁
Want to keep 2 different views of the same Database in Notion? Here's 3 Easy Steps to sync duplicate databases!
Shashwat Talwar
Tricks2 min read
How to make progress bar in Notion?
Learn how to create a kickass Progress Bar in your Notion Tables and Databases. Formula Inside 💯
Sarthak Sharma