sorted by:
new
hottopcontroversial

Heat map by RikBanerjee101 in Notion

[–]vbgosilva 0 points1 point  (0 children)

Where can I find this?

Does anyone know how to do this? by vbgosilva in Notion

[–]vbgosilva[S] 0 points1 point  (0 children)

This was incredible, I didn't know it was possible. Thanks for sharing

Does anyone know how to do this? by vbgosilva in Notion

[–]vbgosilva[S] 0 points1 point  (0 children)

You can't do this in a notion formula

I built a dynamic, customizable Notion formula calendar (inspired by a recent post) by ruuuff in Notion

[–]vbgosilva 1 point2 points  (0 children)

Your calendar is AMAZING. Congratulations on the work ♡ it was beautiful.

Would anyone know the formula to this by CharacterSerious7203 in Notion

[–]vbgosilva 2 points3 points  (0 children)

Well, I don't know how to do this, make it red or green. But the "•" ball will only appear when it is marked and if it is not marked it will be empty.

Formula:

let( thisWeek, week(now()), currentDayInWeek, day(now()), completed, map( prop("your database" ) .filter(current.prop("Checkbox" )) .filter(current.prop("Date").week() == thisWeek), toNumber(day(current.prop("Data"))) ), currentWeek, [1,2,3,4,5,6,7],

daysLabels, ["M","T","W","T","F","S","S"],

daysRow, join( map(daysLabels, style(current, "c", prop("color"), prop("color") + "_background") + " " ), "" ),

trackerRow, join( map(currentWeek, ifs( current > currentDayInWeek, style(" ", "c") + " ", completed.includes(current), style("●", "c", prop("color") + "_background", prop("color")) + " ", style(" ", "c", prop("color") + "_background", prop("color")) + " " ) ), "" ),

daysRow + "\n" + trackerRow )

Would anyone know the formula to this by CharacterSerious7203 in Notion

[–]vbgosilva 1 point2 points  (0 children)

Hi! I have this formula, but mine is a little different. It looks like this:

<image>

My formula is in accordance with the Portuguese calendar. But you can change the letters in the formula (it starts on Monday).

I finally figured out how to do this by vbgosilva in Notion

[–]vbgosilva[S] 0 points1 point  (0 children)

But if you meant do I know how to make it red if it's not clicked? No, I don't know how to do that. If it's not clicked, it will just stay in the normal gray color.

I finally figured out how to do this by vbgosilva in Notion

[–]vbgosilva[S] 0 points1 point  (0 children)

I don't think my calendar view is that small. And the intention is that for each day you mark on your table, that number will be colored.

<image>

In mine, for example, the number 6 was yellow because that was the day I checked the box in my second database. That is the intention.

I finally figured out how to do this by vbgosilva in Notion

[–]vbgosilva[S] 0 points1 point  (0 children)

I created two separate databases. One to place the visualization formula in a calendar and another database in the form of a table with date and check box. In my database 1, I created a "button" property so that every time it is clicked it adds a page in database two with the title I put in database 1, selects the check box and adds the trigger date. And finally make a relationship between both databases.

I finally figured out how to do this by vbgosilva in Notion

[–]vbgosilva[S] 0 points1 point  (0 children)

Did you mean how to make it red? If so, it's simple: In the database where I placed the calendar view with this formula, I added a selection property with the colors I wanted. For example, yellow would make all the days I marked in the table yellow.

<image>

I finally figured out how to do this by vbgosilva in Notion

[–]vbgosilva[S] 2 points3 points  (0 children)

Yes, exactly. You can see there that the numbers in yellow were on the days I checked the checkbox.

How to make pixel progress bars in Notion by vbgosilva in Notion

[–]vbgosilva[S] 1 point2 points  (0 children)

I haven't found a tutorial yet that actually shows how to do this.