
Prop (“Day”) = Tuesday”)?dateAdd(prop( “Week Beginning” ) ,1, “days”) : part of the formula.
Click on the Date to open the Property window. This formula will only work for Monday and Tuesday – for the rest of the week:. Click on “Tuesday” and you’ll see that “Date” has changed to Tuesday’s date. prop (“Day”) = Tuesday”) ?dateAdd(prop( “Week Beginning” ) ,1, “days”) : prop(“Week Beginning”). With this we’re are asking, if the day is “Tuesday,” then add one day to the “Week Beginning,” if it’s not “Tuesday” then use “Week Beginning:”.
Type in ?dateAdd(prop( “Week Beginning” ) ,1, “days”) : prop(“Week Beginning”). For Tuesday, we’ll add one day to the original date. Now we need to add one day to the date column that we’ve put in as “Week Beginning ” otherwise, it will always be Monday. Next to prop (“Day”) enter = (two equals signs) Tuesday”). prop (“Day”) will appear in the “Type a formula” text field at the top. Select “Formula,” then click on the “Empty” field to the right of the ‘Date” property. Click on “Add a property” and name the property “Date,” select “Text” under the Property Type. Because we can’t use a select property to change a date, we’ll use a formula to see the task in a calendar view:. Click on “Assign” and enter “Week Beginning.” This date will only represent which week the task is in. Click on the “Empty” field to the right of “Assign” and select the date. To change the assigned column into a date column, click on “Assign” > “Person” > “Date.”. To display the day, click on “Status” and enter “Day,” then “Multi-select” > “Select.”. To delete the options automatically included – “Not started,” “In progress,” and “Completed.” Click on them, then on the three-dotted icon that appears and select “Delete” > “Remove.”. These will be the titles of the boards to move your tasks to. Then enter all the days of the week by clicking on the “Empty” field to the right of “Status.”. Change the “Select” property to “Multi-select” by clicking on “Select” > “Multi-select.”.
Launch Notion and create a board database view by entering “/board.”.
To make a weekly planner template using the board and calendar view combined: