- Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

Reference In Notion: https://www.notion.so/redgregory/Autopopulate-Dates-3cd20c12722b41599721cdb778b8bc49

More About Notion: https://www.redgregory.com/

For those seeking tips and tricks inside Notion in regards to auto-populating date properties, I've compiled a list of some basic functions. T...
Reference In Notion: https://www.notion.so/redgregory/Autopopulate-Dates-3cd20c12722b41599721cdb778b8bc49

More About Notion: https://www.redgregory.com/

For those seeking tips and tricks inside Notion in regards to auto-populating date properties, I've compiled a list of some basic functions. This tutorial ranges from beginner to novice. Ps. I will make content exclusively for progress bars in the future.

⏱Timestamps

00:53 - Return the year
1:18 - Return the month
2:45 - Return the weekday
4:09 - Return first/second half of the year
5:19 - Return quarter of the year
6:35 - Return date(#)
7:20 - Return week(#)
7:43 - Return time
8:46 - Custom date formats
10:40 - Days elapsed(Now to Date)
12:12 - Return years in date range
13:55 - Return quarter of end date
15:01 - Return days within date range
15:39 - Progress Bar

#Notion #Date #Formula #Notion How To #Notion Tutorial #Database #Progress Bar #Percentage #Automate
If you put  in the timestamps it will put chapters in the video 😁I am curious why don't you use 'q' for quarter or 'Do' or 'Mo' so 'th' is at the end? - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

If you put in the timestamps it will put chapters in the video 😁I am curious why don't you use 'q' for quarter or 'Do' or 'Mo' so 'th' is at the end?

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:00:00 - 00:22:44
- Return the year - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return the year

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:00:53 - 00:01:18
- Return the month - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return the month

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:01:18 - 00:02:45
- Return the weekday - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return the weekday

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:02:45 - 00:04:09
- Return first/second half of the year - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return first/second half of the year

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:04:09 - 00:05:19
- Return quarter of the year - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return quarter of the year

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:05:19 - 00:06:35
- Return date(#) - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return date(#)

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:06:35 - 00:07:20
- Return week(#) - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return week(#)

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:07:20 - 00:07:43
- Return time - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return time

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:07:43 - 00:08:46
- Custom date formats - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Custom date formats

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:08:46 - 00:10:40
- Days elapsed(Now to Date) - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Days elapsed(Now to Date)

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:10:40 - 00:12:12
Those who only wanna know about DATE RANGE move to . BTW really helpful video thanks for making this - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

Those who only wanna know about DATE RANGE move to . BTW really helpful video thanks for making this

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:11:45 - 00:22:44
thank you... just have a question... if I made an only hour column  but I want it to show ONLY what has a time other than am (that its what it gives it for default if no hour is entered) what formula should I use? - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

thank you... just have a question... if I made an only hour column but I want it to show ONLY what has a time other than am (that its what it gives it for default if no hour is entered) what formula should I use?

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:12:00 - 00:22:44
- Return years in date range - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return years in date range

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:12:12 - 00:13:55
- Return quarter of end date - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return quarter of end date

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:13:55 - 00:15:01
- Return days within date range - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Return days within date range

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:15:01 - 00:15:39
- Progress Bar - Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)

- Progress Bar

Notion Formulas 101: Auto-Populate From Dates (Weekday, Days Elapsed, Progress Bar, Etc.)
2020年07月01日 
00:15:39 - 00:22:44

Red Gregory

※本サイトに掲載されているチャンネル情報や動画情報はYouTube公式のAPIを使って取得・表示しています。

Timetable

動画タイムテーブル

動画数:118件

- Intro - How to Build a Second Brain in Notion (+ Free Template)

- Intro

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:00:00 - 00:00:39
- How second brain works - How to Build a Second Brain in Notion (+ Free Template)

- How second brain works

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:00:39 - 00:03:24
- Capture Notes - Setup a notes database - How to Build a Second Brain in Notion (+ Free Template)

- Capture Notes - Setup a notes database

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:03:24 - 00:10:17
- Capture Notes - Remove vertical lines & using filters, sorts - How to Build a Second Brain in Notion (+ Free Template)

- Capture Notes - Remove vertical lines & using filters, sorts

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:10:17 - 00:11:00
- Capture Notes - Grouping table data to minimize space - How to Build a Second Brain in Notion (+ Free Template)

- Capture Notes - Grouping table data to minimize space

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:11:00 - 00:11:38
- Capture Notes - Duplicate database views to save time - How to Build a Second Brain in Notion (+ Free Template)

- Capture Notes - Duplicate database views to save time

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:11:38 - 00:15:22
- Capture Notes - Hiding database properties - How to Build a Second Brain in Notion (+ Free Template)

- Capture Notes - Hiding database properties

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:15:22 - 00:16:35
- Projects - Setup a projects database - How to Build a Second Brain in Notion (+ Free Template)

- Projects - Setup a projects database

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:16:35 - 00:19:31
- Projects - Breakdown projects into manageable tasks - How to Build a Second Brain in Notion (+ Free Template)

- Projects - Breakdown projects into manageable tasks

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:19:31 - 00:23:08
- Projects - Make connections between notes and projects - How to Build a Second Brain in Notion (+ Free Template)

- Projects - Make connections between notes and projects

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:23:08 - 00:27:10
- Projects - Build a progress bar with a rollup - How to Build a Second Brain in Notion (+ Free Template)

- Projects - Build a progress bar with a rollup

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:27:10 - 00:28:10
- Areas - Setup an areas of life database - How to Build a Second Brain in Notion (+ Free Template)

- Areas - Setup an areas of life database

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:28:10 - 00:29:04
- Areas - Convert gallery card into a button layout - How to Build a Second Brain in Notion (+ Free Template)

- Areas - Convert gallery card into a button layout

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:29:04 - 00:31:05
- Areas - A relational template to view captured notes in page body - How to Build a Second Brain in Notion (+ Free Template)

- Areas - A relational template to view captured notes in page body

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:31:05 - 00:37:09
- Areas - Count number of related notes with a rollup & formula - How to Build a Second Brain in Notion (+ Free Template)

- Areas - Count number of related notes with a rollup & formula

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:37:09 - 00:39:32
- Web Bookmarks - Connect notes to projects and areas - How to Build a Second Brain in Notion (+ Free Template)

- Web Bookmarks - Connect notes to projects and areas

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:39:32 - 00:41:47
- Web Bookmarks - Use save to Notion extension for web articles - How to Build a Second Brain in Notion (+ Free Template)

- Web Bookmarks - Use save to Notion extension for web articles

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:41:47 - 00:44:19
- Web Bookmarks - Summarize web articles with Notion AI - How to Build a Second Brain in Notion (+ Free Template)

- Web Bookmarks - Summarize web articles with Notion AI

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:44:19 - 00:47:11
- Resources - Capture tweet thread from the web as callouts - How to Build a Second Brain in Notion (+ Free Template)

- Resources - Capture tweet thread from the web as callouts

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:47:11 - 00:48:53
- Resources - Link an existing database into a separate page - How to Build a Second Brain in Notion (+ Free Template)

- Resources - Link an existing database into a separate page

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:48:53 - 00:51:29
- Archive pages - link multiple existing databases into one block - How to Build a Second Brain in Notion (+ Free Template)

- Archive pages - link multiple existing databases into one block

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:51:29 - 00:53:59
- Share pages - Setup and show linked data to share - How to Build a Second Brain in Notion (+ Free Template)

- Share pages - Setup and show linked data to share

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:53:59 - 00:55:46
- Build a dashboard - How to Build a Second Brain in Notion (+ Free Template)

- Build a dashboard

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
00:55:46 - 01:01:40
- Outro - How to Build a Second Brain in Notion (+ Free Template)

- Outro

How to Build a Second Brain in Notion (+ Free Template)
2023年05月24日 
01:01:40 - 01:02:11
- Intro - Notion for Productivity: Automate Recurring Checklists (Free Template)

- Intro

Notion for Productivity: Automate Recurring Checklists (Free Template)
2023年04月16日 
00:00:00 - 00:01:09
- Project Database - Notion for Productivity: Automate Recurring Checklists (Free Template)

- Project Database

Notion for Productivity: Automate Recurring Checklists (Free Template)
2023年04月16日 
00:01:09 - 00:10:24
- Archive Button - Notion for Productivity: Automate Recurring Checklists (Free Template)

- Archive Button

Notion for Productivity: Automate Recurring Checklists (Free Template)
2023年04月16日 
00:10:24 - 00:15:03
- Outro - Notion for Productivity: Automate Recurring Checklists (Free Template)

- Outro

Notion for Productivity: Automate Recurring Checklists (Free Template)
2023年04月16日 
00:15:03 - 00:15:34
- Intro - Introducing Notion Buttons: A First Look and Free Template

- Intro

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:00:00 - 00:00:42
- Start Day: Button Essentials - Introducing Notion Buttons: A First Look and Free Template

- Start Day: Button Essentials

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:00:42 - 00:06:33
- Edit pages: A Button to Complete Tasks - Introducing Notion Buttons: A First Look and Free Template

- Edit pages: A Button to Complete Tasks

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:06:33 - 00:08:27
- Show pages: A Button to Show Overdue Tasks - Introducing Notion Buttons: A First Look and Free Template

- Show pages: A Button to Show Overdue Tasks

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:08:27 - 00:10:24
- Hide pages: A Button to Hide Overdue Tasks - Introducing Notion Buttons: A First Look and Free Template

- Hide pages: A Button to Hide Overdue Tasks

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:10:24 - 00:11:19
- Expand and Hide Weekly Tasks - Introducing Notion Buttons: A First Look and Free Template

- Expand and Hide Weekly Tasks

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:11:19 - 00:13:43
- Buttons for a Shopping List - Introducing Notion Buttons: A First Look and Free Template

- Buttons for a Shopping List

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:13:43 - 00:17:00
- Buttons and Formulas - Introducing Notion Buttons: A First Look and Free Template

- Buttons and Formulas

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:17:00 - 00:22:44
- Add Confirmation Messages - Introducing Notion Buttons: A First Look and Free Template

- Add Confirmation Messages

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:22:44 - 00:24:50
- Build a Survey - Introducing Notion Buttons: A First Look and Free Template

- Build a Survey

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:24:50 - 00:27:44
- Outro - Introducing Notion Buttons: A First Look and Free Template

- Outro

Introducing Notion Buttons: A First Look and Free Template
2023年03月27日 
00:27:44 - 00:28:29
- Intro - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

- Intro

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日 
00:00:00 - 00:00:20
- Weekly Calendar Overview - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

- Weekly Calendar Overview

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日 
00:00:20 - 00:01:15
- Create Weekly Spread - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

- Create Weekly Spread

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日 
00:01:15 - 00:10:28
"LT" for  PM - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

"LT" for PM

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日  Red Gregory 様 
00:03:30 - 00:03:30
"h:mmA" for PM - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

"h:mmA" for PM

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日  Red Gregory 様 
00:03:30 - 00:11:06
"h:mma" for pm - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

"h:mma" for pm

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日  Red Gregory 様 
00:03:30 - 00:03:30
- - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

-

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日  Justine Yu 様 
00:05:00 - 00:06:30
Hi! For some reason when I enter in an event for - - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

Hi! For some reason when I enter in an event for -

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日  Justine Yu 様 
00:05:30 - 00:06:30
, the formula will automatically say it is from - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

, the formula will automatically say it is from

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日  Justine Yu 様 
00:06:30 - 00:05:00
and will state the start time half an hour earlier than indicated in the date? - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

and will state the start time half an hour earlier than indicated in the date?

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日  Justine Yu 様 
00:06:30 - 00:11:06
Hi, this tutorial was great! Thank you very much, it helped me a lot 🤩 I just noticed an issue in the formula to show the time range: a lot of my tasks start for example at am and finish for example at 10am, and that doesn't appear correctly. And sometimes I have days in which tasks/events are very very long, and I need to see for example "8am-9pm". So I implemented the formula this way: - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

Hi, this tutorial was great! Thank you very much, it helped me a lot 🤩 I just noticed an issue in the formula to show the time range: a lot of my tasks start for example at am and finish for example at 10am, and that doesn't appear correctly. And sometimes I have days in which tasks/events are very very long, and I need to see for example "8am-9pm". So I implemented the formula this way:

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日  Giusy Garzone 様 
00:08:30 - 00:11:06
- Outro - New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)

- Outro

New! Notion Feature: Weekly Calendar for Task Planning! (Free Template)
2023年02月27日 
00:10:28 - 00:11:06
- Intro - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

- Intro

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日 
00:00:00 - 00:00:48
- My Workflow Tour: Purpose - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

- My Workflow Tour: Purpose

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日 
00:00:48 - 00:01:38
- My Workflow Tour: My Project Database - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

- My Workflow Tour: My Project Database

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日 
00:01:38 - 00:07:15
Ok so now you need to do a tutorial on how to wireframe/conceptualize in the Concepts app because I have this app and I didn’t know it could look like that…Please and thank you 😊 - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

Ok so now you need to do a tutorial on how to wireframe/conceptualize in the Concepts app because I have this app and I didn’t know it could look like that…Please and thank you 😊

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日  Nikki's Art Videos 様 
00:02:35 - 00:33:32
- Build a Planner: Ideas Outlines w/ Sub-Items - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

- Build a Planner: Ideas Outlines w/ Sub-Items

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日 
00:07:15 - 00:17:01
- Build a Planner: Organize Projects w/ Sprints - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

- Build a Planner: Organize Projects w/ Sprints

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日 
00:17:01 - 00:21:56
- Build a Planner: Schedule Projects w/ Dependencies - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

- Build a Planner: Schedule Projects w/ Dependencies

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日 
00:21:56 - 00:28:13
- Build a Planner: Navigating Project Pages - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

- Build a Planner: Navigating Project Pages

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日 
00:28:13 - 00:33:03
- Outro - Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)

- Outro

Build My Notion Planner: Convert Ideas into Actionable Steps (Free Template)
2023年02月15日 
00:33:03 - 00:33:32