Do you want to learn how to automatically change a Notion database property value depending on the value of another property?
Then you have come to the right place. Keep reading!
How To Automatically Change Property Based On Another Property
At the time of writing, there’s no inherent option to automatically change “Select” and “Multi-Select” based on the value of another property. Never fear, there is a workaround!
Here are the three steps to automatically change a tag based on the value of another property.
- Add a Formula property to the Notion database
- Add an IF formula based on the required conditions
- Hide the database property that the formula replaces
Check out the Notion Foundation series for more tips on using Notion databases.
Worked Example – Show An Overdue Tag
Let’s use this task manager example. I would like to display an “Overdue” tag if the deadline exceeds today’s date.
Here are the steps to create an automatic tag based on the “Due Date” column:
- Add a new “Formula” property
- Now we need to include a simple formula that says, if the “Due Date” column exceeds today’s date, then show “Overdue”, if not, leave it blank. Use this formula – if(prop(“Due Date”) < now(), “Overdue”, “”) and click “Done”.
Worked Example – Change The Priority Tag Based On The Status Property
Say you want to remove the tag in the “Priority” property once the “Status” is changed to “Done”. Use this formula – if(prop(“Status”) != “Done”, prop(“Priority”), “”).
What this formula is saying is – if the “Status” property is not “Done”, then take the “Priority” property value, if not then show a blank entry (i.e. no priority once a task is done!)
The last step is to hide the existing “Priority” property or move the far right of your database table (in case you want to quickly access it). Test out the formula by changing the “Status” to “Done”.
Thanks for reading and I hope this was helpful!
Looking for a simple to-do list? Check out the Minimalist To-Do List Template which includes a free download!