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 TalwarTopic archive
Fantastic Formulas
Practical Notion ideas, workflows and inspiration collected in one place.
Latest in Fantastic Formulas
Updated as new posts arriveShashwat 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
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