Hi, I have a “Current Tasks” column in my Projects tab linking to my Tasks tab. I’ve set it up this way so that when I create a project, I can insert a current task and it automatically creates a task in the Task tab.
However, this might not be the best setup.
I would like for the “Current Task” column in the Project tab to be updated based on my “Completed?” checkbox column in the Tasks tab: if a task is completed, I want it to stay in the Tasks tab, but disappear from the “Current Task” column in Projects. I also have a “Task Completed?” look-up column in Projects looking up the “Completed?” column in Tasks. I don’t know If there’s a formula I should be using instead of a link. I’m open to having to assign tasks in my Tasks tab, but I’d still like to see them in the Projects tab and have them updated upon completion.