How to Clear Your Gallery View of Empty Properties
September 1, 2023
If you've been using formulas, you've probably noticed that in a gallery view, empty spaces or zeros can be a bit unsightly, right?
Well, I've been there too, and I didn't like it, especially when I had limited space in my view. Those empty spaces just made things look messy.
But guess what? I discovered a neat trick to hide those spaces by adding a little magic to my formulas.
Here's the secret:
End your formulas with "If" conditions and finish them with double quotation marks ("").Boom! Just like that,
those annoying empty spaces vanish, and your cards look sleek and clean, displaying only the data you have. The empty properties are still there, but if they don't have a value, they stay hidden.Take a look at this image.
Can you figure out the equations I've used? You can easily copy this line and adapt it to your own formulas.
if(empty(prop("Count")) or empty(prop("Total")), toNumber(""), prop("Count") / prop("Total"))
Have you tried it yet? It looks pretty awesome, right?
I've applied this trick to all my formulas, and it has made a world of difference.
That's it for this tip! If you have more questions or need help implementing it in your workspace, feel free to drop a comment or message me on your favorite social media platform. I'm available to assist you anytime.
Wishing you a fantastic day,
Fayed out
Read more:
5 Books to Help You Crush Your New Year's Resolutions 2024
Dec 14, 2023
Productivity
Transform your 2024 with these 5 must-reads: Atomic Habits for habits, 7 Habits for success, Mindset for growth, Power of Now for peace, and Deep Work for focus. Elevate your year!
Read Post
⇗
Unlocking the Power of Speed Reading: Tips for Faster, Smarter Learning
Oct 5, 2023
Tips
Reading is an essential skill in today's information-driven world. Whether you're a student, a professional, or just someone who loves to read, the ability to process information quickly can be a game-changer. That's where speed reading comes into play.
Read Post
⇗
Why You Should Build Your Own Life Planner: Unleash the Planner Pro in You!
Sep 29, 2023
Productivity
Have you ever felt like life is a never-ending rollercoaster, and you're just along for the ride, hoping for the best? That's where a life planner comes into play. In this article, we'll explore why you should take the reins of your life and build a personal life planner that's as unique as you are.
Read Post
⇗
Stay On Track with Notion: Mastering Custom Reminders for Ultimate Productivity!
Sep 28, 2023
Tips
These days can be a bit of a rollercoaster, right? So many tasks, and oh, those distractions! 😅 Sometimes, I feel like I'm losing track of time and my to-dos.
Read Post
⇗
Cool and Clean: Mastering 'Round' Syntax in Notion Formulas
Sep 14, 2023
Tips
Ever come across this ugly: 33.3333333333%? Oh yes, it's the superstar of numbers, and we've all seen it one too many times, right? But why, oh why, does it have to be this way? It's like the number version of an overcrowded bus—ugly and chaotic. 🚌
Read Post
⇗
How to Optimize your "If" formulas | Mastering 'If' Conditions: Formula Secrets Unleashed!
Sep 7, 2023
Tips
Today, we've got a tip that's cooler than the flip side of the pillow. 🛏️ It's the kind of tip that might make you say, "Duh, I've been doing this since the Stone Age!" But guess what? Not everyone's been rocking the formula boat as smoothly as you might think.
Read Post
⇗
How to Clear Your Gallery View of Empty Properties
Sep 1, 2023
Tips
If you've been using formulas, you've probably noticed that in a gallery view, empty spaces or zeros can be a bit unsightly, right?
Read Post
⇗
How to Make a Relation Between Databases in Notion
Jun 5, 2023
Tips
Database relationships are a fundamental concept in database management. They refer to the way two or more tables are connected or linked to each other based on their data attributes.
Read Post
⇗
How to manage your Money as a professional
May 13, 2023
Productivity
The Money Tracker Notion template is a powerful tool for managing your finances. It is designed to help you keep track of your accounts, budgets, expenses, subscriptions and goals all in one place.
Read Post
⇗
Organize Your YouTube Experience with This Powerful Notion Template
May 1, 2023
Templates
If you're a YouTube enthusiast, you're familiar with the challenge of organizing channels, playlists, and videos. Discover how a dedicated Notion template can simplify your YouTube experience and content discovery.
Read Post
⇗
Benefits of Budgeting and Budget Techniques
Apr 30, 2023
Templates
Budgeting is a fundamental aspect of managing personal and business finances that helps individuals and organizations control their spending, allocate resources effectively, and plan for the future. In this article, we will explore the benefits of budgeting
Read Post
⇗
Financial Knowledge: Why It's Essential for Your Financial Health and Wealth
Apr 23, 2023
Tips
Financial knowledge is one of the most important skills you can possess in today's world. It enables you to make informed financial decisions, plan for your future, and avoid financial pitfalls that can lead to debt and financial instability
Read Post
⇗
How the P.A.R.A. System and a One-Page Template Can Help You Simplify Your Life and Achieve Your Goals
Apr 9, 2023
Templates
The P.A.R.A. system, which stands for Projects, Areas, Resources, and Archives, is a productivity framework created by Tiago Forte. It's designed to help individuals and teams organize their digital lives by separating information into different categories.
Read Post
⇗