# Create Task list - with option to mark as complete

**URL:** <https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971>\
**Category:** Ask for Help\
**Created:** [October 7, 2019, 5:07pm UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971 "2019-10-07T17:07:49Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andy\_Young](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_young/32/796_2.png) [@Andy\_Young](https://community.glideapps.com/u/Andy_Young)\
**Post date:** [October 7, 2019, 5:07pm UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/1 "2019-10-07T17:07:49Z")

</div>

Hi All. I have looked and can’t seem to find an answer to this, but I apologise if it’s obvious (new to this)

I am trying to build an app for our sales and operational teams that allows the monitoring of project tasks.

The main issue I’m struggling with is, I have a set of tasks that I want to track, in the app. I want the users to log in, check project status and see which tasks are marked as complete, and which arent…

I can create a checkbox that marks an action in isolation, but doing it doesn’t keep it referenceable within the app.

For the sake of clarity, here is what I have:

- Main screen: List of project names with image
- Drill down screen: 2 buttons - 1. Project Status Update (I want this to be a check list) - 2. Report an issue (I have this done, based on the issue tracker template.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 7, 2019, 6:17pm UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/2 "2019-10-07T18:17:07Z")

</div>

Take a look at my demo app and look at the Tasks demo. You can copy it to play with and to see the sheet. My example is a a single list that can be viewed and marked completed by multiple users. It may not be exactly what you are looking for, but hopefully it will give you ideas.

[https://concepts.glideapp.io/](https://concepts.glideapp.io/)

---

<div class="post-metadata">

**Author:** ![Andy\_Young](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_young/32/796_2.png) [@Andy\_Young](https://community.glideapps.com/u/Andy_Young)\
**Post date:** [October 7, 2019, 7:33pm UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/3 "2019-10-07T19:33:25Z")

</div>

Thanks Jeff for the quick response. I have had a quick look and will play around. It seems like exactly what I’m after isn’t avaiable. I am, however, grateful for your reply.

Thanks again

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 8:27pm UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/4 "2019-10-07T20:27:02Z")

</div>

@Andy_Young the beauty of Glide is that if you find something close to what you want you can usually adapt it to what you want. For instance I did a search here on “task completed” and came up with this post:

> [@Help designing spredsheet/Glide - Curriculum with many user](https://community.glideapps.com/t/help-designing-spredsheet-glide-curriculum-with-many-user/813):
>
> I would like some help designing my spreadsheet and Glide properly for the following situation: I have a Curriculum where by my salespeople need to complete a task and mark it “complete”. The Curricuum has over 120 tasks (the one I’m sharing is just a small sample). There are about 60 reps that will go through the Curricumum. I know how to use the “sign in by email” feature and how to add a column with a user’s email to filter that row’s data to that user. My question is, with so …

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 8, 2019, 1:10am UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/5 "2019-10-08T01:10:14Z")

</div>

Just curious, are your list of tasks always the same, or are they unique to a project? If they are always the same, then you could create a column for each task in your project sheet. Then when you are viewing the project, you can enable editing and then when you edit the record, you can create a checkbox for each column task that your want to check off.

I’m not sure I follow what you mean by this quote.

> [@Andy\_Young](#):
>
> I can create a checkbox that marks an action in isolation, but doing it doesn’t keep it referenceable within the app.

I’m making assumptions based what you noted in your first post, so I’m not exactly sure what you are going for.

---

<div class="post-metadata">

**Author:** ![Andy\_Young](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_young/32/796_2.png) [@Andy\_Young](https://community.glideapps.com/u/Andy_Young)\
**Post date:** [October 8, 2019, 8:56am UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/6 "2019-10-08T08:56:30Z")

</div>

Hi Again, Jeff. Thanks for still thinking about this.

My meaning was that, I found a way to go into the peroject and check a box against a task. But when you close and re-open, you are able to check that same task again. It doesn’t reference and show, that it was completed already.

---

<div class="post-metadata">

**Author:** ![Andy\_Young](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_young/32/796_2.png) [@Andy\_Young](https://community.glideapps.com/u/Andy_Young)\
**Post date:** [October 8, 2019, 9:00am UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/7 "2019-10-08T09:00:48Z")

</div>

Hi George,

Thanks for the advice, I actually found that post and a couple of others when researching. I didn’t think it suited my needs, but the problem is, I’m not technical, so I might not be fully grasping what the outcome was.

I had a an idea last night that I am going to try and play with today and see if that works for me.

Thanks again.

---

<div class="post-metadata">

**Author:** ![Andy\_Young](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_young/32/796_2.png) [@Andy\_Young](https://community.glideapps.com/u/Andy_Young)\
**Post date:** [October 8, 2019, 10:56am UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/8 "2019-10-08T10:56:16Z")

</div>

Hi @Jeff_Hager & @George_B

Here is the App as I have it so far. [Https://projectstatustracker.glideapp.io](Https://projectstatustracker.glideapp.io)

The main thing I would love to be able to do, is drill down into the individual live projects, and see what tasks in the project management stages are complete. If I could, then it would be great to have a percent complete bar

I have tried to replicate the solution tsam posted on Georges referenced post but It’s how to display the results I’m struggling with. I only found out about glide on sunday, so I’m still trying to figure it out.

Sorry to be a pain, but any suggestions are really appreciated.

---

<div class="post-metadata">

**Author:** ![Spellytics](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spellytics/32/2770_2.png) [@Spellytics](https://community.glideapps.com/u/Spellytics)\
**Post date:** [October 9, 2019, 10:20pm UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/9 "2019-10-09T22:20:02Z")

</div>

Hi Andy,

I am overcoming the same sort of problem.  
Mmmm there are a few ways to do it.

1. Add another sheet to list all the projects. You can use the UNIQUE function to dynamically generate the list.

In that sheet, add a column using countifs for the total number of tasks related to that project. And another column with a countifs for the number of tasks completed for each project. The % will give you the progress bar.

1. To list the completed task associated with each project, you can use an inline reference I think. It is a bit hacky - but you can create a project id with a suffix of completed. E.g. 001-completed. Each task should have this id once it is completed. This will allow you to list all completed items related to that project instead of all the items. There might be better ways of doing this.

2. To list all completed tasks regardless of a project, you can add another tab linked to your task sheet and add a filter for Completed. You can do the same for tasks that the user created.

I also use a checkbox or toggle switch to indicate completion/resolution of an issue.

Hope that helps.

---

<div class="post-metadata">

**Author:** ![Andy\_Young](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_young/32/796_2.png) [@Andy\_Young](https://community.glideapps.com/u/Andy_Young)\
**Post date:** [October 10, 2019, 12:22pm UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/10 "2019-10-10T12:22:29Z")

</div>

Hi Spellytics,  
Thanks for the input. I think I have cracked it. Its clunky and def not as elegant as it could be, but feel free to have a look and tell me what you think.

---

<div class="post-metadata">

**Author:** ![geordiep](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geordiep/32/5586_2.png) [@geordiep](https://community.glideapps.com/u/geordiep)\
**Post date:** [October 2, 2020, 7:10pm UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/11 "2020-10-02T19:10:49Z")

</div>

HI Jeff  
I’m trying to track tasks that are completed with in the app so that rather than going through each item with in a tab. here is my link for the app [https://3tipn.glideapp.io/](https://3tipn.glideapp.io/). their for have to create a tab which is the easy part, its viewing the completed tasks iv got to try and link together.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 3, 2020, 12:53am UTC](https://community.glideapps.com/t/create-task-list-with-option-to-mark-as-complete/971/12 "2020-10-03T00:53:46Z")

</div>

What are you asking? I’m not sure I understood if you have a question.
