Tasks

The Tasks database stores all of your tasks. It’s the primary database that drives task management in Ultimate Brain. (Here’s how to find it in your template)

Below you’ll find a reference guide for all database templates and properties in the Tasks database. Properties are in alphabetical order.

Note: In versions of Ultimate Brain released prior to November 2024, this database is called All Tasks.

These are the database templates that can be found in this database. Refer to our guide on working with database templates if you’d like to edit them or create new ones.

This template lets you easily add sub-tasks to a task. Note that while you can technically apply this template to sub-task pages themselves (effectively creating sub-sub-tasks), Ultimate Brain really only supports a single level of sub-tasks due to core Notion limitations.

This simple template shows how you can use To Do blocks to create a re-usable checklist for travel purposes.

Type: People

Use this property to set assignees for each task.

Note that Ultimate Brain is set up for individual use by default; to make this property useful, you’ll want to create filtered views that only show tasks assigned to specific people.

Type: Date

The date on which this task was completed.

Type: Multi Select

Allows you to apply GTD-style contexts to your tasks. In Process → Do Next, you’ll find a view where you can group your tasks by context.

NameDescription
High-EnergyTasks that require a lot of mental energy.
Low-EnergyTasks that require only a small amount of mental energy.
ErrandErrands that have to be done outside the home.
HomeTasks that need to be done in/around your home.
OfficeTasks that need to be done at the office.
SocialTasks that involve talking or working with other people.
ShoppingShopping-related tasks. This Context is used to power the Shopping page within Recipes.

Type: Created Time

The date and time the task was created.

Type: Created By

The user (or integration) who created the task.

Type: Multi Select

Allows you to pick specific days of the week for a task to recur – e.g. Mon/Wed/Fri.

As noted by the property name, this property only take effect if Recur Interval is 1 and Recur Unit is set to Day(s) (or is blank).

NameDescription
MondayN/A
TuesdayN/A
WednesdayN/A
ThursdayN/A
FridayN/A
SaturdayN/A
SundayN/A

Type: Rich Text

A simple text property for adding a note about this task.

If you’ve added the Notion AI add-on to your workspace, you can turn AI Autofill on to generate a summary of the task’s details (provided there’s a full description in the task’s page body).

Type: Date

The due date for the task.

Note that most filters in Ultimate Brain filter against the End Date of Due. This doesn’t affect pages with a single date, but does come into play if you set a start and end date.

Type: Formula

If a task is sub-task, this returns the Due Timestamp value of its parent task. Otherwise, it simply returns this task’s own Due Timestamp value.

This property is the highest-priority sorting criteria for Task views within Projects. It keeps sub-tasks beneath their parent tasks.

!prop("Parent Task")
	? prop("Due Timestamp")
	: prop("Parent Task").first().prop("Due Timestamp")
Code language: JavaScript (javascript)

Type: Formula

Used to aid in correctly sorting tasks and sub-tasks within Projects.

If the task doesn’t have a Due date set, this timestamp will be 100 years in the future. This simply keeps tasks/sub-tasks without a due date below tasks that have one.

!prop("Due")
	? now().dateAdd(100, "years").timestamp()
	: prop("Due").timestamp()
Code language: JavaScript (javascript)

Type: Last Edited Time

The date and time the task was last edited.

Type: Last Edited By

The user (or integration) who last edited the task.

Type: Formula

Used for sorting sub-tasks underneath their parent tasks in the Process → Task Intake view.

If the task is a sub-task, this returns the last edited time of its parent as a timestamp. Otherwise, it returns this task’s own last edited time as a timestamp.

!prop("Parent Task")
	? prop("Edited").timestamp()
	: prop("Parent Task").first().prop("Edited").timestamp()
Code language: JavaScript (javascript)

Type: Multi Select

This property was previously called “Tag” in Ultimate Brain 3.0 prior to December 6, 2024. It was renamed on that date to prevent confusion with the Tags database, since Ultimate Brain doesn’t ship with a relation between this Tasks database and the Tags database by default.

Allows you to add labels to tasks, which will allow you to create label-based Board views in Project pages.

Useful if you want to organize tasks in a project by type – e.g. Dev, Marketing, etc. Unlock the Tasks db to add options.

This property has no options by default. Unlock the Tasks database in order to add options.

(Known as Kanban – Tag in previous versions of UB.)

Type: Formula

This property allows you to localize your template. If you want to translate the option names in the Days, Recur Unit, and Status properties, you can do so and then change the arrays in this formula to the same values.

This will allow formulas to keep working.

[
/* Rewrite these weekday and recur unit options in your own language, so your second brain can work even better with your first. Make sure to set up the same options in the "Recur Unit" and "Days (Only If Set to 1 Day(s))" properties afterward, so you can select them. Feel free to remove the original names afterward! */

/* ["lunes", "3ª", "mercredi", "木曜日", "piątek", "lørdag", "Double Sunday"] */
["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"],

/* ["Day(s)", "Week(s)", "Month(s)", "Year(s)", "Month(s) on the Last Day", "Month(s) on the First Weekday", "Month(s) on the Last Weekday"] */
["Day(s)", "Week(s)", "Month(s)", "Year(s)", "Month(s) on the Last Day", "Month(s) on the First Weekday", "Month(s) on the Last Weekday"],

/* This final list is for Status option names. */
["To Do", "Doing", "Done"]
]
Code language: JavaScript (javascript)

Type: Formula

Used in List views to show if a task is recurring, and/or if it has unfinished sub-tasks.

lets(
	recurring,
	if(
		not empty(prop("Next Due")),
		"🔁",
		""
	),
	hasSubtask,
	if(
		prop("Sub-Tasks").filter(current.prop("Status") != "Done").length() > 0,
		"↳",
		""
	),
	[recurring, hasSubtask].join(" ").replace("^\s","").replace("\s$","")
)
Code language: JavaScript (javascript)

Type: Checkbox

If checked, this task will show up in the Execute view of the My Day page.

Use this property to plan out the tasks you’re going to do today (regardless of their due date).

Type: Formula

This simple property just displays the text “My Day”. It is used on the My Day page to label the My Day checkbox, making it visually distinct from the Status checkbox that is always shown to the left of task names.

let(
	showLabel,
	true,
	if(
		showLabel,
		"My Day",
		""
	)
)
Code language: JavaScript (javascript)

Type: Title

The name of the task.

Type: Formula

The “next due” date for the task if it is recurring. A date will show here once you have values set in the Due and Recur Interval properties.

The date is calculated the Due date, today’s date, and the values in Recur Interval, Recur Unit, and Days (Only if Set to 1 Day(s)).

lets(
	dueProp, prop("Due"),
	
	recurIntervalProp, prop("Recur Interval"),
	
	recurUnitProp, prop("Recur Unit"),
	
	localizationKeyProp, prop("Localization Key"),
	
	emptyDate, parseDate(""),
	
	if(!empty(recurIntervalProp) and !empty(dueProp),
		if(recurIntervalProp > 0 and recurIntervalProp == ceil(recurIntervalProp),
			lets(
				recurUnit,
					ifs(
						or(recurUnitProp == at(at(localizationKeyProp, 1), 0), recurUnitProp == "Day(s)"), "days",
						or(recurUnitProp == at(at(localizationKeyProp, 1), 1), recurUnitProp == "Week(s)"), "weeks",
						or(recurUnitProp == at(at(localizationKeyProp, 1), 2), recurUnitProp == "Month(s)"), "months",
						or(recurUnitProp == at(at(localizationKeyProp, 1), 3), recurUnitProp == "Year(s)"), "years",
						or(recurUnitProp == at(at(localizationKeyProp, 1), 4), recurUnitProp == "Month(s) on the Last Day"), "monthsonthelastday",
						or(recurUnitProp == at(at(localizationKeyProp, 1), 5), recurUnitProp == "Month(s) on the First Weekday"), "monthsonthefirstweekday",
						or(recurUnitProp == at(at(localizationKeyProp, 1), 6), recurUnitProp == "Month(s) on the Last Weekday"), "monthsonthelastweekday",
						"days"
					),
				
				weekdays,
					match(
						[
							if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 1 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Monday")), 1, false),
							if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 2 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Tuesday")), 2, false),
							if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 3 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Wednesday")), 3, false),
							if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 4 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Thursday")), 4, false),
							if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 5 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Friday")), 5, false),
							if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 6 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Saturday")), 6, false),
							if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 7 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Sunday")), 7, false)
						],
						"[1-7]"
					),
				
				dateDue, parseDate(formatDate(dueProp, "YYYY-MM-DD")),
				
				timeNow, now(),
				
				dateNow, parseDate(formatDate(timeNow, "YYYY-MM-DD")),
				
				hasRange, dateEnd(dueProp) > dateStart(dueProp),
				
				recurUnitLapseLength,
					if(
						includes(["days", "weeks", "months", "years"], recurUnit),
						dateBetween(dateNow, dateDue, recurUnit) / recurIntervalProp,
						false
					),
				
				lastDayBaseDate,
					if(
						includes(["monthsonthelastday", "monthsonthefirstweekday", "monthsonthelastweekday"], recurUnit),
						if(
							year(dateNow) * 12 + month(dateNow) - (year(dateDue) * 12 + month(dateDue)) > 0,
							dateSubtract(dateAdd(dateSubtract(dateAdd(dateDue, ceil((year(dateNow) * 12 + month(dateNow) - (year(dateDue) * 12 + month(dateDue))) / recurIntervalProp) * recurIntervalProp, "months"), date(dateAdd(dateDue, ceil((year(dateNow) * 12 + month(dateNow) - (year(dateDue) * 12 + month(dateDue))) / recurIntervalProp) * recurIntervalProp, "months")) - 1, "days"), 1, "months"), 1, "days"),
							dateSubtract(dateAdd(dateSubtract(dateAdd(dateDue, recurIntervalProp, "months"), date(dateAdd(dateDue, recurIntervalProp, "months")) - 1, "days"), 1, "months"), 1, "days")
						),
						emptyDate
					),
				
				firstDayBaseDate,
					if(
						lastDayBaseDate != emptyDate,
						dateSubtract(lastDayBaseDate, date(lastDayBaseDate) - 1, "days"),
						emptyDate
					),
				
				firstWeekdayBaseDate,
					if(
						lastDayBaseDate != emptyDate,
						if(
							test(day(firstDayBaseDate), "6|7"), 
							dateAdd(firstDayBaseDate, 8 - day(firstDayBaseDate), "days"),
							firstDayBaseDate
						),
						emptyDate
					),
				
				lastWeekdayBaseDate,
					if(
						lastDayBaseDate != emptyDate,
						if(
							test(day(lastDayBaseDate), "6|7"), 
							dateSubtract(lastDayBaseDate, day(lastDayBaseDate) - 5, "days"),
							lastDayBaseDate
						),
						emptyDate
					),
				
				nextLastBaseDate,
					if(
						lastDayBaseDate != emptyDate,
						dateSubtract(dateAdd(dateSubtract(dateAdd(lastDayBaseDate, recurIntervalProp, "months"), date(dateAdd(lastDayBaseDate, recurIntervalProp, "months")) - 1, "days"), 1, "months"), 1, "days"),
						emptyDate
					),
				
				nextFirstBaseDate,
				if(
					lastDayBaseDate != emptyDate,
					dateSubtract(nextLastBaseDate, date(nextLastBaseDate) - 1, "days"),
					emptyDate
				),
				
				nextFirstWeekday,
					if(
						lastDayBaseDate != emptyDate,
						if(
							test(day(nextFirstBaseDate), "6|7"), 
							dateAdd(nextFirstBaseDate, 8 - day(nextFirstBaseDate), "days"),
							nextFirstBaseDate
						),
						emptyDate
					),
				
				nextLastWeekday,
					if(
						lastDayBaseDate != emptyDate,
						if(
							test(day(nextLastBaseDate), "6|7"), 
							dateSubtract(nextLastBaseDate, day(nextLastBaseDate) - 5, "days"),
							nextLastBaseDate
						),
						emptyDate
					),
				
				nextDueStart,
					ifs(
						recurUnit == "days" and length(weekdays) > 0 and recurIntervalProp == 1, 
							if(
								dateNow >= dateDue,
								ifs(
									includes(weekdays, format(day(dateAdd(dateNow, 1, "days")))), dateAdd(dateNow, 1, "days"),
									includes(weekdays, format(day(dateAdd(dateNow, 2, "days")))), dateAdd(dateNow, 2, "days"),
									includes(weekdays, format(day(dateAdd(dateNow, 3, "days")))), dateAdd(dateNow, 3, "days"),
									includes(weekdays, format(day(dateAdd(dateNow, 4, "days")))), dateAdd(dateNow, 4, "days"),
									includes(weekdays, format(day(dateAdd(dateNow, 5, "days")))), dateAdd(dateNow, 5, "days"),
									includes(weekdays, format(day(dateAdd(dateNow, 6, "days")))), dateAdd(dateNow, 6, "days"),
									includes(weekdays, format(day(dateAdd(dateNow, 7, "days")))), dateAdd(dateNow, 7, "days"),
									emptyDate
								),
								ifs(
									includes(weekdays, format(day(dateAdd(dateDue, 1, "days")))), dateAdd(dateDue, 1, "days"),
									includes(weekdays, format(day(dateAdd(dateDue, 2, "days")))), dateAdd(dateDue, 2, "days"),
									includes(weekdays, format(day(dateAdd(dateDue, 3, "days")))), dateAdd(dateDue, 3, "days"),
									includes(weekdays, format(day(dateAdd(dateDue, 4, "days")))), dateAdd(dateDue, 4, "days"),
									includes(weekdays, format(day(dateAdd(dateDue, 5, "days")))), dateAdd(dateDue, 5, "days"),
									includes(weekdays, format(day(dateAdd(dateDue, 6, "days")))), dateAdd(dateDue, 6, "days"),
									includes(weekdays, format(day(dateAdd(dateDue, 7, "days")))), dateAdd(dateDue, 7, "days"),
									emptyDate
								)
							),

						recurUnit == "monthsonthelastday",
							if(
								dateNow >= lastDayBaseDate,
								nextLastBaseDate,
								lastDayBaseDate
							),
						
						recurUnit == "monthsonthefirstweekday",
							if(
								dateNow >= firstWeekdayBaseDate,
								nextFirstWeekday,
								firstWeekdayBaseDate
							),
						
						recurUnit == "monthsonthelastweekday",
							if(
								dateNow >= lastWeekdayBaseDate,
								nextLastWeekday,
								lastWeekdayBaseDate
							),
						
						includes(["days", "weeks", "months", "years"], recurUnit), 
							if(
								dateBetween(dateNow, dateDue, "days") >= 1,
								if(
									recurUnitLapseLength == ceil(recurUnitLapseLength),
									dateAdd(dateDue, (recurUnitLapseLength + 1) * recurIntervalProp, recurUnit),
									dateAdd(dateDue, ceil(recurUnitLapseLength) * recurIntervalProp, recurUnit)
								),
								dateAdd(dateDue, recurIntervalProp, recurUnit)
							),

						emptyDate
					),
				
				recurRange, dateBetween(nextDueStart, dateDue, "days"),
				
				timeNextDueStart, dateAdd(dateStart(dueProp), recurRange, "days"),
				
				timeNextDueEnd, dateAdd(dateEnd(dueProp), recurRange, "days"),
				
				nextDue,
					if(
						hasRange,
						dateRange(timeNextDueStart, timeNextDueEnd),
						timeNextDueStart
					),
				
				nextDue
			),
			dueProp
		),
		emptyDate
	)
)
Code language: JavaScript (javascript)

Type: Formula

This formula takes the Date value from the Next Due property, separates the start and end dates (if an end date is present), and formats the output as a JSON string. Used exclusively by Pipedream for automated recurring tasks (you shouldn’t edit it).

let(
	nextDueAPI,
		lets(
			dueProp, prop("Due"),
			
			recurIntervalProp, prop("Recur Interval"),
			
			recurUnitProp, prop("Recur Unit"),
			
			localizationKeyProp, prop("Localization Key"),
			
			if(
				!empty(recurIntervalProp) and !empty(dueProp),
				if(
					recurIntervalProp > 0 and recurIntervalProp == ceil(recurIntervalProp),
					lets(
						recurUnit, ifs(
							or(recurUnitProp == at(at(localizationKeyProp, 1), 0), recurUnitProp == "Day(s)"), "days",
							or(recurUnitProp == at(at(localizationKeyProp, 1), 1), recurUnitProp == "Week(s)"), "weeks",
							or(recurUnitProp == at(at(localizationKeyProp, 1), 2), recurUnitProp == "Month(s)"), "months",
							or(recurUnitProp == at(at(localizationKeyProp, 1), 3), recurUnitProp == "Year(s)"), "years",
							or(recurUnitProp == at(at(localizationKeyProp, 1), 4), recurUnitProp == "Month(s) on the Last Day"), "monthsonthelastday",
							or(recurUnitProp == at(at(localizationKeyProp, 1), 5), recurUnitProp == "Month(s) on the First Weekday"), "monthsonthefirstweekday",
							or(recurUnitProp == at(at(localizationKeyProp, 1), 6), recurUnitProp == "Month(s) on the Last Weekday"), "monthsonthelastweekday",
							"days"
						),
						
						weekdays,
							match(
								[
									if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 1 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Monday")), 1, false),
									if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 2 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Tuesday")), 2, false),
									if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 3 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Wednesday")), 3, false),
									if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 4 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Thursday")), 4, false),
									if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 5 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Friday")), 5, false),
									if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 6 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Saturday")), 6, false),
									if(or(includes(prop("Days (Only if Set to 1 Day(s))"), at(at(localizationKeyProp, 0), 7 - 1)), includes(prop("Days (Only if Set to 1 Day(s))"), "Sunday")), 7, false)
								],
								"[1-7]"
							),
						
						dateDue, parseDate(formatDate(dueProp, "YYYY-MM-DD")),
						
						dateDueEnd, parseDate(formatDate(dateEnd(dueProp), "YYYY-MM-DD")),
						
						timeNow, now(),
						
						offsetTimeNow, dateAdd(timeNow, prop("UTC Offset"), "hours"),

						inUTC,
							if(
								formatDate(now(), "ZZ") == "+0000",
								true,
								false
							),
						
						hasValidOffset,
							if(
								!empty(prop("UTC Offset")) and prop("UTC Offset") >= -12 and prop("UTC Offset") <= 14,
								true,
								false
							),
						
						hasRange, dateEnd(dateDueEnd) > dateStart(dateDue),
						
						dueRange, dateBetween(dateDueEnd, dateDue, "days"),
						
						conditionalTimeNow,
							if(
								inUTC and hasValidOffset,
								offsetTimeNow,
								timeNow
							),
						
						conditionalDateNow, parseDate(formatDate(conditionalTimeNow, "YYYY-MM-DD")),
						
						recurUnitLapseLength,
							if(
								includes(["days", "weeks", "months", "years"], recurUnit),
								dateBetween(conditionalDateNow, dateDue, recurUnit) / recurIntervalProp,
								false
							),
						
						lastDayBaseDate,
							if(
								includes(["monthsonthelastday", "monthsonthefirstweekday", "monthsonthelastweekday"], recurUnit),
								if(
									year(conditionalDateNow) * 12 + month(conditionalDateNow) - (year(dateDue) * 12 + month(dateDue)) > 0,
									dateSubtract(dateAdd(dateSubtract(dateAdd(dateDue, ceil((year(conditionalDateNow) * 12 + month(conditionalDateNow) - (year(dateDue) * 12 + month(dateDue))) / recurIntervalProp) * recurIntervalProp, "months"), date(dateAdd(dateDue, ceil((year(conditionalDateNow) * 12 + month(conditionalDateNow) - (year(dateDue) * 12 + month(dateDue))) / recurIntervalProp) * recurIntervalProp, "months")) - 1, "days"), 1, "months"), 1, "days"),
									dateSubtract(dateAdd(dateSubtract(dateAdd(dateDue, recurIntervalProp, "months"), date(dateAdd(dateDue, recurIntervalProp, "months")) - 1, "days"), 1, "months"), 1, "days")
								),
								false
							),
						
						firstDayBaseDate,
							if(
								lastDayBaseDate != false,
								dateSubtract(lastDayBaseDate, date(lastDayBaseDate) - 1, "days"),
								false
							),
						
						firstWeekdayBaseDate,
							if(
								lastDayBaseDate != false,
								if(
									test(day(firstDayBaseDate), "6|7"), 
									dateAdd(firstDayBaseDate, 8 - day(firstDayBaseDate), "days"),
									firstDayBaseDate
								),
								false
							),
						
						lastWeekdayBaseDate,
							if(
								lastDayBaseDate != false,
								if(
									test(day(lastDayBaseDate), "6|7"), 
									dateSubtract(lastDayBaseDate, day(lastDayBaseDate) - 5, "days"),
									lastDayBaseDate
								),
								false
							),
						
						nextLastBaseDate,
							if(
								lastDayBaseDate != false,
								dateSubtract(dateAdd(dateSubtract(dateAdd(lastDayBaseDate, recurIntervalProp, "months"), date(dateAdd(lastDayBaseDate, recurIntervalProp, "months")) - 1, "days"), 1, "months"), 1, "days"),
								false
							),
						
						nextFirstBaseDate,
							if(
								lastDayBaseDate != false,
								dateSubtract(nextLastBaseDate, date(nextLastBaseDate) - 1, "days"),
								false
							),
						
						nextFirstWeekday,
							if(
								lastDayBaseDate != false,
								if(
									test(day(nextFirstBaseDate), "6|7"), 
									dateAdd(nextFirstBaseDate, 8 - day(nextFirstBaseDate), "days"),
									nextFirstBaseDate
								),
								false
							),
						
						nextLastWeekday,
							if(
								lastDayBaseDate != false,
								if(
									test(day(nextLastBaseDate), "6|7"), 
									dateSubtract(nextLastBaseDate, day(nextLastBaseDate) - 5, "days"),
									nextLastBaseDate
								),
								false
							),
						
						nextDueStart,
							ifs(
								recurUnit == "days" and length(weekdays) > 0 and recurIntervalProp == 1,
									if(
										conditionalDateNow >= dateDue,
										ifs(
											includes(weekdays, format(day(dateAdd(conditionalDateNow, 1, "days")))), dateAdd(conditionalDateNow, 1, "days"),
											includes(weekdays, format(day(dateAdd(conditionalDateNow, 2, "days")))), dateAdd(conditionalDateNow, 2, "days"),
											includes(weekdays, format(day(dateAdd(conditionalDateNow, 3, "days")))), dateAdd(conditionalDateNow, 3, "days"),
											includes(weekdays, format(day(dateAdd(conditionalDateNow, 4, "days")))), dateAdd(conditionalDateNow, 4, "days"),
											includes(weekdays, format(day(dateAdd(conditionalDateNow, 5, "days")))), dateAdd(conditionalDateNow, 5, "days"),
											includes(weekdays, format(day(dateAdd(conditionalDateNow, 6, "days")))), dateAdd(conditionalDateNow, 6, "days"),
											includes(weekdays, format(day(dateAdd(conditionalDateNow, 7, "days")))), dateAdd(conditionalDateNow, 7, "days"),
											false
										),
										ifs(
											includes(weekdays, format(day(dateAdd(dateDue, 1, "days")))), dateAdd(dateDue, 1, "days"),
											includes(weekdays, format(day(dateAdd(dateDue, 2, "days")))), dateAdd(dateDue, 2, "days"),
											includes(weekdays, format(day(dateAdd(dateDue, 3, "days")))), dateAdd(dateDue, 3, "days"),
											includes(weekdays, format(day(dateAdd(dateDue, 4, "days")))), dateAdd(dateDue, 4, "days"),
											includes(weekdays, format(day(dateAdd(dateDue, 5, "days")))), dateAdd(dateDue, 5, "days"),
											includes(weekdays, format(day(dateAdd(dateDue, 6, "days")))), dateAdd(dateDue, 6, "days"),
											includes(weekdays, format(day(dateAdd(dateDue, 7, "days")))), dateAdd(dateDue, 7, "days"),
											false
										)
									),
								
								recurUnit == "monthsonthelastday",
									if(
										conditionalDateNow >= lastDayBaseDate,
										nextLastBaseDate,
										lastDayBaseDate
									),
								
								recurUnit == "monthsonthefirstweekday",
									if(
										conditionalDateNow >= firstWeekdayBaseDate,
										nextFirstWeekday,
										firstWeekdayBaseDate
									),
								
								recurUnit == "monthsonthelastweekday",
									if(
										conditionalDateNow >= lastWeekdayBaseDate,
										nextLastWeekday,
										lastWeekdayBaseDate
									),
								
								includes(["days", "weeks", "months", "years"], recurUnit), 
									if(
										dateBetween(conditionalDateNow, dateDue, "days") >= 1,
										if(
											recurUnitLapseLength == ceil(recurUnitLapseLength),
											dateAdd(dateDue, (recurUnitLapseLength + 1) * recurIntervalProp, recurUnit),
											dateAdd(dateDue, ceil(recurUnitLapseLength) * recurIntervalProp, recurUnit)
										),
										dateAdd(dateDue, recurIntervalProp, recurUnit)
									),
								false
							),
						
						nextDueEnd,
							if(
								hasRange and nextDueStart != false, 
								dateAdd(nextDueStart, dueRange, "days"),
								false
							),
						
						nextDue,
							if(
								hasRange and nextDueEnd != false,
								dateRange(nextDueStart, nextDueEnd),
								nextDueStart
							),
						
						nextDue
					),
					false
				),
				false
			)
		),

	if(
		nextDueAPI == false,
		"∅",
		"{\"start\":\"" + formatDate(dateStart(nextDueAPI), "YYYY-MM-DD") + "\",\"end\":\"" + formatDate(dateEnd(nextDueAPI), "YYYY-MM-DD") + "\"}"
	)
)
Code language: JavaScript (javascript)

Type: Relation

Past, finished occurrences of a recurring task.

This is part of Task History for recurring tasks. To enable it, unlock your Tasks database. Click the ⚡️ to access Automations, then de-activate Recurring Tasks (Simple), and activate Recurring Tasks (Advanced). Learn more in the Recurring Tasks guide.

Type: Rollup

If this page is a sub-task, this Rollup property shows the Project of its parent task (if it has one).

Type: Rollup

If this task is a sub-task, this Rollup property gets the calculated Smart List from its parent task.

Type: Relation

If the current page is a sub-task, its parent task page will be shown here.

This property is a Relation which connects to another property inside this same All Tasks database.

Type: Relation

This relation property connects to the People database. You can use it to associate tasks with other people.

For example, in the Delegated view of the Process dashboard, you can use this relation to note the person to whom you’ve delegated a task.

Type: Status

Priority level for your task. By default, this value only matters in the special Priority View. Priority doesn’t affect task sorting or visibility in other views – but you can add Priority filters or grouping to them if you want.

NameDescription
Group: To-do
Group: In progress
LowFor low-priority tasks.
MediumFor medium-priority tasks.
HighFor high-priority tasks.
Group: Complete

Type: Relation

This Relation connects to the Projects database, allowing you to associate a project with your tasks.

Type: Formula

This property shows whether this task’s project is active (either Doing or Ongoing). Used for views that only show tasks within projects that are active – helpful for filtering out tasks in projects that are planned, but not yet in progress.

This property’s value differs between the standalone Ultimate Brain template and the fully-integrated Ultimate Brain + Creator’s Companion template.

This version of the Project Active formula is found in the base version of Ultimate Brain.

lets(
	project,
	if(
		prop("Parent Task"),
		prop("Parent Task").first().prop("Project").first(),
		prop("Project").first()
	),
	projectStatus,
	project.prop("Status"),
	projectLocalizationKey,
	project.prop("Localization Key"),
	if(
		projectStatus == "Doing" 
		or projectStatus == "Ongoing"
		or projectLocalizationKey.at(1).includes(projectStatus),
		true,
		false
	)
)
Code language: JavaScript (javascript)

This version of the Project Active formula is found in the fully-integrated version of Ultimate Brain + Creator’s Companion.

It checks both normal Projects, as well as content projects in the Content database, to determine in the task is part of an active project.

lets(
	project,
	if(
		prop("Parent Task"),
		prop("Parent Task").first().prop("Project").first(),
		prop("Project").first()
	),
	projectStatus,
	project.prop("Status"),
	projectLocalizationKey,
	project.prop("Localization Key"),
	content,
	if(
		prop("Parent Task"),
		prop("Parent Task").first().prop("Content").first(),
		prop("Content").first()
	),
	contentStatus,
	content.prop("Status"),
	contentLocalizationKey,
	content.prop("Localization Key"),
	projectActive,
	if(
		projectStatus == "Doing" 
		or projectStatus == "Ongoing"
		or projectLocalizationKey.at(1).includes(projectStatus),
		true,
		false
	),
	contentActive,
	if(
		contentStatus == "Research"
		or contentStatus == "Writing"
		or contentStatus == "Filming"
		or contentStatus == "Review"
		or contentStatus == "Recording"
		or contentStatus == "Editing"
		or contentStatus == "Ready to Publish"
		or contentStatus == "Needs Update"
		or contentLocalizationKey.at(1).includes(contentStatus),
		true,
		false
	),
	if(
		projectActive or contentActive,
		true,
		false
	)
)
Code language: JavaScript (javascript)

Type: Rollup

If this task is related to a Project, this Rollup property shows the Project’s Area (if it has one).

Type: Number

How often to make a recurring task recur. By default, this interval is a number of days -e.g an interval of 2 make Next Due two days from Due (or today’s date). You can set a Recur Unit to adjust this.

Type: Select

Sets the unit of time that will be used by Recur Interval to set Next Due. E.g. if you set Week(s) here, then a Recur Interval of 2 will set a task to recur every 2 weeks.

NameDescription
Day(s)N/A
Week(s)N/A
Month(s)N/A
Month(s) on the First WeekdayN/A
Month(s) on the Last WeekdayN/A
Month(s) on the Last DayN/A
Year(s)N/A

Type: Formula

This formula property just helps to visually separate the recurring tasks helper properties below (which should not be edited) from the rest above.

repeat("■", 3).style("red") + " Recurring Tasks helper properties".style("b")
Code language: JavaScript (javascript)

Type: Select

Allows you to send tasks to specific lists in the Process (GTD) page, which allows you to practice GTD (Getting Things Done) in Notion.

The Due and Snooze properties also factor into these lists; tasks with a Due date go to the Calendar, and tasks with a Snooze date go to Deferred.

NameDescription
Do Next“Next Actions” in GTD terms.
DelegatedTasks that you’ve delegated to another person.
SomedayTasks that you may do someday, but you’re not committed to right now.

Type: Formula

This formula determines which Smart List (aka GTD list) a task is currently on. Used in the Process page.

It takes into account the following properties: Due, Snooze, and Smart List.

Possible values (in priority order): Calendar, Do Next, Delegated, Snoozed, Someday, Inbox.

ifs(
	prop("Due"),
	"Calendar",
	prop("Smart List") == "Do Next" or prop("Smart List") == "Delegated", 
	prop("Smart List"), 
	prop("Snooze"),
	"Snoozed",
	prop("Smart List") == "Someday", 
	prop("Smart List"), 
	"Inbox"
)
Code language: JavaScript (javascript)

Type: Date

Used in the Process and Process → Deferred pages for practicing GTD in Notion.

Adding a Snooze date moves a task to the Deferred list/page.

Note that only tasks without a Due date will show there. Due (Calendar) has higher priority than Snooze (Deferred).

Type: Formula

If this task is a sub-task of a parent task that is Snoozed, this returns that parent task’s Snooze date as a timestamp. Otherwise, it returns this task’s own Snooze date as a timestamp.

Aids in sorting sub-tasks beneath their parent tasks in Process → Snoozed.

!prop("Parent Task").first().prop("Snooze")
	? prop("Snooze").timestamp()
	: prop("Parent Task").first().prop("Snooze").timestamp()
Code language: JavaScript (javascript)

Type: Status

Tracks the status of the task. Most views in Ultimate Brain show this property as a checkbox.

Checking the checkbox will alternate Status between “To Do” and “Done”. ⌥/Alt + Click the checkbox in order to access all options, including “Doing”.

NameDescription
Group: To-do
To DoTasks that you need to do.
Group: In progress
DoingTasks you’re currently doing.
Group: Complete
DoneTasks that are done.

Type: Formula

Indents sub-tasks in List views. This template does not use Notion’s native sub-items feature, as it can cause unexpected results and user confusion in this template’s Projects database template.

ifs(
	prop("Parent Task"), 
	"→"
)
Code language: JavaScript (javascript)

Type: Formula

Used in Projects, alongside Due Stamp (Parent), to ensure that sub-tasks are sorted correctly beneath their parent tasks.

lets(
	subSeedName,
	if(
		!prop("Parent Task"),
		prop("Name").lower(),
		prop("Parent Task").first().format().lower()
	),
	subSeed,
	if(
		!prop("Parent Task"),
		1,
		2
	),
	taskStatus,
	if(
		prop("Status") == "Done" or prop("Status") == prop("Localization Key").at(2).last(),
		2,
		1
	),
	taskStatus + " - " + subSeedName + " - " + subSeed
)
Code language: JavaScript (javascript)

Type: Relation

If the current task page is a Parent Task, all of its sub-tasks will be shown here.

This is a Relation property, which is connected to the Parent Task Relation property in this same All Tasks database.

Type: Formula

Your UTC offset, based on your location (e.g. -6 for Denver during DST time, -7 at other times).

This property is set automatically by my automated recurring tasks Pipedream workflow, so you don’t need to edit it.

Ultimate Brain 3.0 also comes with native automated recurring tasks using Notion database automations, so this property likely won’t be used at all. It’s only used if you’re using the Pipedream workflow.

0
Code language: JavaScript (javascript)

Type: Formula

If this task is a sub-task of a parent task that has a Wait Date, this returns that parent task’s Wait Date as a timestamp. Otherwise, it returns this task’s own Wait Date as a timestamp.

Aids in sorting sub-tasks beneath their parent tasks in Process → Delegated.

!prop("Parent Task").first().prop("Wait Date")
	? prop("Wait Date").timestamp()
	: prop("Parent Task").first().prop("Wait Date").timestamp()
Code language: JavaScript (javascript)

Type: Date

Used to note the date you delegated a task to someone else. This is most useful in Process → Delegated, which functions as the Delegated list for practicing GTD in Notion.

The fully-integrated version of Ultimate Brain + Creator’s Companion contains a few exclusive Tasks properties that are not found in the standalone version of Ultimate Brain.

In addition to these properties, the Project Active formula property (listed above) has a different formula in UB + CC compared to standalone UB.

Type: Relation

Tasks that are part of this content project. This Relation property connects to the Content Relation property in the Tasks database.

Type: Rollup

If this page’s task is a sub-task, this Rollup property shows the Content project of the Parent Task (if one is set).

Primarily useful for making the Task With Sub-Tasks database template work as expected.

🤔 Have an UB Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas

🤔 Have a Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas