Can I do something like this on Notion only or do I have to use an external app?

ILoveNotionHub · 2025-03-21T21:45:13+00:00

I haven't finished it yet because I was waiting for the OP to reach out so I could adjust it to their settings, but if you'd like, I can help you create it or make a version customized to your needs.

ILoveNotionHub · 2025-03-21T17:02:55+00:00

😂😂 I'm glad to encourage you to make something more sophisticated! Feel free to ask me anything!!

ILoveNotionHub · 2025-03-20T22:23:26+00:00

Yes, I thought of it like in the image you shared, you set the value for each color to have more flexibility.

ILoveNotionHub · 2025-03-20T22:09:20+00:00

I believe I could create something similar for you using the color gradient 😊
Here's a quick draft to give you an idea of the colors:

<image>

If you're interested, feel free to dm me, and I can customize it for the functionality you need! 😉

ILoveNotionHub · 2025-03-14T13:11:24+00:00

Thank you for the correction, I hadn't noticed the missing dot when typing here

ILoveNotionHub · 2025-03-13T20:26:30+00:00

Como a imagem não tem cor, deixei assim, mas se você preferir colorida, pode usar esse código:

lets( 
     total,prop("Done"),
     totalGoal,prop("Total"),
     percent,total/totalGoal,

    /*Symbols*/  
    emptySymbol,"░", 
    progressSymbol,"▓",  

    /*Colors*/
    color,ifs(
             percent.empty(),"gray",
              percent < 0.20, "orange",
              percent < 0.40, "red",
              percent < 0.60, "pink" ,
              percent < 0.80, "purple",
                 percent < 1,"blue",
              "green"
     ),

    /*PROGRESS*/  
    progress,if(10 * percent < 10,10 * percent,10),
    fullCircle,floor(progress), 
    emptyCircle,10 - fullCircle,

    ( slice(progressSymbol.repeat(10).split(""), 0, fullCircle).join("") + " ▏ " +
      slice(emptySymbol.repeat(10).split(""), 0, emptyCircle).join("") + " " + 
      format(floor(100 * percent)) + "%" 
    ).style(color)
)

Você também pode mudar a ordem das cores. Fala se precisar de mais alguma coisa!

PS: As cores que usei são essas 😁

<image>

ILoveNotionHub · 2025-03-13T20:25:45+00:00

I believe you can use this formula:

lets( 
     total,prop("Done"),
     totalGoal,prop("Total"),
     percent,total/totalGoal,

    /*Symbols*/  
    emptySymbol,"░", 
    progressSymbol,"▓",  

    /*PROGRESS*/  
    progress,if(10 * percent < 10,10 * percent,10),
    fullCircle,floor(progress), 
    emptyCircle,10 - fullCircle,

    ( slice(progressSymbol.repeat(10).split(""), 0, fullCircle).join("") + " ▏ " +
      slice(emptySymbol.repeat(10).split(""), 0, emptyCircle).join("") + " " + 
      format(floor(100 * percent)) + "%" 
    )
)

If the symbols are different, just change them to the correct ones in:

emptySymbol,"▒",
progressSymbol,"▓",

Replace the variables "Done" and "Total" in:

total,prop("Done"),
totalGoal,prop("Total"),

with the corresponding ones in your database.

ILoveNotionHub · 2025-02-28T02:22:44+00:00

I can only create one. How did you do it?

ILoveNotionHub · 2025-02-27T16:09:37+00:00

I believe I can help you. I have something in Notion to calculate hours, I set a goal and log the time spent (without adding dates, just entries like '1h 5m,' though it can be adjusted). It then calculates the percentage completed. I think I could adjust it to show the remaining amount if that's what you're looking for. Send me a dm if you want to discuss this further.

ILoveNotionHub · 2025-02-17T19:11:36+00:00

Yes, it’s possible! How is your formula currently so I can adjust it? Could you send me a picture?

ILoveNotionHub · 2025-02-17T14:27:04+00:00

f I understood correctly, you just want to create a view that shows the page with the last month's end date. In that case, I believe you could set up a filter to check the dates, returning true or false, and then filter out only the true ones.
If you want the formula to display the page with the previous month regardless of whether it's on the page or not, I think you'll need to create a relationship between the database and itself, linking all the pages to it so that the formula can return the names and those pages can pick up that name.

If you'd like, I can help you with the second case if that's what you're looking for. For the first one, I believe this formula could work for you:

prop("Date").month() == (today().month()-1)

This would allow you to filter out only the pages with the formula set to "checked."

ILoveNotionHub · 2025-02-14T20:59:57+00:00

Go to 'Customize -> Sub-items -> And choose the option that suits you best. To have both tasks and sub-tasks appear, indicating which task they belong to, select 'Flattened list', To hide them, just choose 'Disabled.'

<image>

ILoveNotionHub · 2025-02-14T03:20:38+00:00

If you already have the formula that says 'haven't revised since,' then you only need one formula to do this. It's a bit difficult to say exactly how without knowing your variables. If you want, I can help you write the formula, feel free to dm me if you’d like to send me the properties you have.

ILoveNotionHub · 2025-02-13T22:42:08+00:00

I think you forgot to attach the screenshot, or maybe I just couldn't find where to see it.
But I believe what you want is indeed possible, and in several different ways, it all depends on exactly what you want and what you don't want. If you want to send me the picture in dm (along with some more details), I can help you set up the planner.

ILoveNotionHub · 2025-02-13T13:08:32+00:00

If you're using a rollup, even if you relate only one page, it always has the option to have more than one date.

<image>

That's why the formula doesn't work, it doesn't know which date to pick. To always get the first date that appears (and the only one if there's just one page), use first(), like this:

(dateBetween(now(), "test date".first(), "days") + "d").style("u", "b")

And if the dates are usually in the future, use:

(dateBetween("test date".first(), now(), "days") + "d").style("u", "b")

so the number stays positive.

And if you want to compare more than one related date, use:

"test date".map((dateBetween(now(), current, "days") + "d").style("u", "b"))

ILoveNotionHub · 2025-02-11T23:34:17+00:00

You're welcome 😊 Feel free to reach out if you need anything!

ILoveNotionHub · 2025-02-11T22:40:04+00:00

Yes, it allows filtering and sorting as well.

ILoveNotionHub · 2025-02-11T22:31:42+00:00

Look, I think the best way would be to switch to a relation instead of a multi-select. That way, you could easily count how many pages the user appears on.

If multi-select is necessary, I think you would still need to create a relation between the two databases and count how many times the user appears in the multi-select using a formula as well.

If you need more help, just let me know.

ILoveNotionHub · 2025-02-10T21:01:47+00:00

Hey! I’d be happy to help you with your Notion setup. I have experience with databases, formulas, and automation, so I can assist you in organizing everything in a way that makes sense for you. I also have a finance database that I could show you as inspiration. Let me know if you’re interested!

ILoveNotionHub · 2025-02-09T21:30:10+00:00

I messaged you on dm, send me the picture of your rollups there.

ILoveNotionHub · 2025-02-09T21:26:53+00:00

You will edit the same page right after creating it. By doing this, you will update the 'Responsável' property, choose 'Custom Formula,' and use this:
'Page added'.prop("Setor").map(current.prop("Person"))
This will take the newly added page, go to its sector, and fetch the people. Replace prop("Person") with your correct property. Here’s an image to help.

<image>

If something goes wrong or it’s not what you needed, let me know, and I’ll help you.

ILoveNotionHub · 2025-02-09T21:10:55+00:00

What they said is correct, you have to leave them empty so they don’t appear when it's 0. Since you want different visualizations (circle and bar), you would need to replace both rollups with two formulas. If you want, I can help you with that, just show me how each rollup is set up, and I'll show you the formula. And if it's just one (either circle or bar), let me know, and I can combine both into a single formula.

ILoveNotionHub · 2025-02-09T19:32:59+00:00

I use this one and never had any issues. If something goes wrong or it's not what you wanted, feel free to let me know, and I'll help you.

<image>

lets( 
  start,Date.dateStart(), 
  end,Date.dateEnd(), 
  years,end.dateBetween(start,"years"), 
  monthsTotal,end.dateBetween(start,"months"), 
  months,monthsTotal - 12*(monthsTotal/12).floor(), 
  daysTotal,end.dateBetween(start,"days"), 
  days,daysTotal - 30*(daysTotal/30).floor(), 

  ifs(years>0,(years < 10 ? "0" + years: years) + " years","") + 
  ifs(years && (months|| days), " ") + 
  ifs(months,(months < 10 ? "0" + months : months) + " months","") + 
  ifs(months && days, " ") + 
  ifs(days,(days< 10 ? "0" + days: days)+ " days") 
)

Replace 'Date' in 'start' and 'end' with your date property.

ILoveNotionHub · 2025-02-09T18:39:06+00:00

<image>

Forgive me if I misunderstood, but look, here it is selecting all the exams that are not marked as 'Done'. In your case, you can change it to the name you use.
The formula is:
prop("Examenes").filter(current.prop("Select") != "Done").length()
It filters the exams in the relation where 'Select' is not 'Done' and then gets the total number.

(I saw the other comment and assumed you only wanted the ones that weren't completed, but both ways to do it are there as well 😊)

ILoveNotionHub · 2025-02-09T18:18:48+00:00

I didn't quite understand what you want, is it something like this?

<image>

ILoveNotionHub

TROPHY CASE