3-2-1: Notion!

The weekly newsletter that keeps you up to date with Notion’s latest features, tips, tutorials, & resources.

→ My Notion templates: ramesquinerie.com/templates
→ You can find my services, blog & more on my website: ramesquinerie.com

In this week’s issue of 3-2-1:

• Arrange your sidebar

• AI suggested properties

• Sync parent-task dates with sub-task dates

• Automated reports (BOW / EOW)

• Guide to company Notion

Hey — it's Rames

Went hiking this weekend. Still in Parque Natural los Alcornocales — it's so huge it's going to take more than a few weekends to visit it all. Beautiful sceneries, as always.

Also added a few animals to our collection — we've seen strange insects, deer (one of them lost its antler), beautiful eagles, and adorable donkeys.

And before we begin... This week's sponsor...

The best “build once, sell twice” asset.

While most creators sleep on email courses, the best ones scale with them.

Sign up for Master the Email-Based Course and see why Dickie Bush had “Takeaways within 5 minutes... Huge value.” 

Get $50 off for the next 48 hours with code LEAD.

👉 Want to get in front of 8,2k Notion users? Book your spot here.

3 Tips

1/ Arrange your sidebar

Your sidebar is now "yours." You can rearrange sections (by drag & drop) to display your favorite/most used sections at the very top! Enjoy 😋

2/ AI suggested properties

Notion now suggests AI properties based on your database content. I'm not fully convinced by Notion's AI yet, but this is a step in the right direction.

3/ Sync parent-task dates with sub-task dates

If you're using Notion's sub-items feature, you might find the lack of cohesion between parent-items and sub-items somewhat frustrating. For instance, wouldn't it be convenient if the parent task's "date" property could automatically update based on the dates of its sub-tasks?

I attempted to solve this problem using formulas. Here's what I devised for the date example:

/* Differenciate parent-tasks from sub-tasks (+sub-tasks with empty due dates) */
if(or(empty(prop("Parent-task"))==false,empty((map(prop("Sub-tasks"),current.prop("Due"))).format().replaceAll(",",""))==true),prop("Due"),
	/* Create the parent task range */
	dateRange(map(
	/* Get sub-tasks */
	prop("Sub-tasks"),
	/* Get sub-tasks due dates */
	current.prop("Due").dateStart())
/* Sort dates in ascending order */
.sort()
/* Get the most recent date */
.first()
/* Get its start date */
.dateStart(),

	/* Repeat for end date */
	map(prop("Sub-tasks"),	current.prop("Due").dateEnd()).sort().last().dateEnd())
)

This formula essentially generates a new date range for the parent tasks, using the earliest start date and the latest end date from all of its sub-tasks.

If you want to apply this formula to your own task manager, remember to name your properties as follows:

• Parent task (relation) → "Parent-task"

• Sub task (relation) → "Sub-tasks"

• Date (date) → "Due"

2 Resources

1/ Ziki’s automated reports

Just stumbled on this wonderful system for generating BOW (beginning of week) and EOW (end of week) reports based on your Notion tasks database. It's entirely constructed within Notion, utilizing formulas and database automations. Truly impressive.

Awesome build, Ziki 👏

2/ Josh’s guide to company Notion

Here's another quality thread from Josh Redd about building your company's operating system in Notion.

1 Tweek: Tweet of the Week

Rames Quinerie

aaaa

Friends of Notion 🤝

• Learn Notion on Skillshare: five awesome courses to up your game

• Make: the #1 automation app — connect Notion to all your other tools

• Noteforms: (one of) the best form builders that syncs your answers with Notion

• Tally: (also one of) the best form builders that syncs your answers with Notion

• Super: the #1 Notion-powered web builder

• Notionlytics: more detailed Notion analytics for knowledge management

• Notion AI / Q&A: bring some AI-magic to your Notion workspace

• Senja: embed your customer testimonials on your Notion website