Hey folks! I’m trying to set up a smart system in my Notion database. I’ve got three main fields: Task, Status, and Done. Here’s what I want to happen automatically:
- When I mark
Status as Finished
- The
Done field should get a new tag matching the Task name
Task should change to Completed- The old
Task tag should disappear
Right now, these are all multi-select fields, but I can switch them to single-select if needed.
I’m not great with formulas, but I heard Notion can do this kind of thing. Can anyone help me figure out how to make tags ‘move’ between properties? Thanks!
As someone who’s experimented extensively with Notion databases, I can offer a workaround for your automation needs. While Notion doesn’t support direct tag movement between properties, you can create a system that simulates this effect.
Consider using a formula property to display the task name when the status is ‘Finished’. This can serve as your ‘Done’ field. For the task disappearing aspect, another formula property can show the task name only when the status isn’t ‘Finished’.
To streamline this process, I’d recommend utilizing Notion’s native ‘Status’ property instead of a custom one. This allows for better integration with other Notion features and potential future updates.
For full automation, exploring third-party integration tools like Zapier or Automate.io might be beneficial. These can monitor your database and trigger updates across multiple fields based on your specified conditions.
This approach, while not perfect, closely approximates the automated tag movement you’re aiming for without necessitating complex formula structures or significant database restructuring.
hey ryan, i’ve played around with this before. notion can’t auto-move tags between properties, but you can fake it with formulas. try using a formula field that shows the task name when status is ‘finished’. for the disappearing part, make another formula that only displays the task if status isn’t ‘finished’. it’s not perfect but gets close!
I’ve faced a similar challenge in my Notion setup, and I can share what worked for me. While Notion’s formula capabilities are impressive, they can’t directly modify other properties. However, you can achieve a similar effect using a combination of formulas and automations.
For your specific case, I’d recommend using Notion’s built-in ‘Status’ property instead of a custom one. This allows you to leverage the ‘Done’ status. Then, create a formula property that checks if the status is ‘Done’ and, if so, outputs the task name. You can use this formula as a reference for your ‘Done’ field.
For the task disappearing part, you could use another formula property that shows the task name only if the status isn’t ‘Done’. This gives the illusion of the task moving.
To fully automate the process, you might want to look into integrating Notion with tools like Zapier or Make (formerly Integromat). These can monitor your database for changes and update multiple fields automatically based on your criteria.
It’s not a perfect solution, but it gets pretty close to what you’re aiming for without requiring complex formulas or database restructuring.