# How to Display Incomplete Tasks in a Column? **URL:** \ **Category:** Ask for Help\ **Created:** [May 31, 2024, 1:52pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778 "2024-05-31T13:52:52Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [May 31, 2024, 1:52pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/1 "2024-05-31T13:52:52Z")
I have two columns in Relation: one with all the tasks a user must complete (let’s say 20 tasks) and one with all the tasks they have completed (let’s say 5 tasks). I want to find a way to display only the tasks that are not yet completed in a new column (in this case, a list of 15 tasks). I tried doing this via a Query and using ‘is not included in,’ but it’s not working. How can I achieve this? ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [May 31, 2024, 2:57pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/2 "2024-05-31T14:57:06Z")
The way I can think of is that you use the remove elements column, but your column must be in an array. With a query it might be possible, but you should provide a screenshot of what your data looks like. If your all tasks data is in array, then you can use ‘does not contain’ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 1, 2024, 12:29am UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/3 "2024-06-01T00:29:31Z")
What is your ultimate goal for displaying the tasks **in a column**? Also, why are you using “is not included in”? Can you show us your data structure? ---
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [June 4, 2024, 8:03am UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/4 "2024-06-04T08:03:52Z")
> [@ThinhDinh](#): > > What is your ultimate goal for displaying the tasks **in a column**? I want one type of user to have access to tasks not yet validated by another. At present, he can only see those that have been validated. > [@ThinhDinh](#): > > Also, why are you using “is not included in”? Because with this, I thought I’d be able to select, in the list of global tasks, only those that weren’t (weren’t included in…) in the list of validated tasks. > [@ThinhDinh](#): > > Can you show us your data structure? Yes. I have the Users table, which has a Multiple Files column with the array of validated task IDs (Trebuchet method from Robert Petitto’s video). I also have a lookup of all the tasks it has to complete. ---
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [June 11, 2024, 12:28pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/5 "2024-06-11T12:28:21Z")
Any help? 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 12, 2024, 12:39am UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/6 "2024-06-12T00:39:42Z")
I’m still unclear about your data structure. Is there a reason why you don’t just have a list of tasks on their own rows, and have a boolean to know whether they have been completed or not? ---
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [June 12, 2024, 1:26pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/7 "2024-06-12T13:26:22Z")
Yes, because a given user’s task completion must be monitored by others (his managers). ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 12, 2024, 2:10pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/8 "2024-06-12T14:10:26Z")
So multiple people can do the same task, and you’re tracking their task completion using Trebuchet? ---
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [June 12, 2024, 2:39pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/9 "2024-06-12T14:39:48Z")
Yes 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 12, 2024, 2:44pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/10 "2024-06-12T14:44:20Z")
I’m not sure if query supports this, can you try querying the Tasks table, filter by rowID is not included in the “multiple files” column that you’re storing completed tasks? ---
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [June 12, 2024, 3:29pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/11 "2024-06-12T15:29:37Z")
I can’t filter on a “multiple files” column ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 12, 2024, 11:41pm UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/12 "2024-06-12T23:41:23Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55bfe6a2ecfeb6753c795cf72479b27634174c83.png) You can add a joined list column to join all the IDs of “finished tasks”, then do a query like this on the Tasks table. ---
**Author:** ![LVaurie](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@LVaurie](https://community.glideapps.com/u/LVaurie)\ **Post date:** [June 13, 2024, 8:09am UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/13 "2024-06-13T08:09:30Z")
Thanks! It works 🙂 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 20, 2024, 8:10am UTC](https://community.glideapps.com/t/how-to-display-incomplete-tasks-in-a-column/73778/14 "2024-06-20T08:10:14Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.