# User-specific checklist with progress status

**URL:** <https://community.glideapps.com/t/user-specific-checklist-with-progress-status/44689>\
**Category:** Ask for Help\
**Created:** [July 18, 2022, 2:23am UTC](https://community.glideapps.com/t/user-specific-checklist-with-progress-status/44689 "2022-07-18T02:23:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Olivia\_Green](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/olivia_green/32/1642_2.png) [@Olivia\_Green](https://community.glideapps.com/u/Olivia_Green)\
**Post date:** [July 18, 2022, 2:23am UTC](https://community.glideapps.com/t/user-specific-checklist-with-progress-status/44689/1 "2022-07-18T02:23:33Z")

</div>

Hello! The scenario is I have 10 tasks for 2 separate categories (5 tasks each). The tasks/checklist completed are user specific but when it calculates the user’s progress within one category it shows 2/10 completed instead of 2/5 tasks completed because it is counting all of the tasks in one column. What is the best way to set up my Gsheet?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 18, 2022, 2:47am UTC](https://community.glideapps.com/t/user-specific-checklist-with-progress-status/44689/2 "2022-07-18T02:47:23Z")

</div>

Sounds like you just need to separate your task list into two columns - one for each category.

If you need both categories of task to be completed for each of the 5, what you can do is use an if-then-else column (in the Glide Data Editor), and configure it as follows:

- If category A task is not checked, then null (empty)
- If category B task is not checked, then null
- Else true

And then all you need is a rollup column to count the number of completed tasks - counting the number of true values in the if-then-else column.

---

<div class="post-metadata">

**Author:** ![Olivia\_Green](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/olivia_green/32/1642_2.png) [@Olivia\_Green](https://community.glideapps.com/u/Olivia_Green)\
**Post date:** [July 18, 2022, 3:48am UTC](https://community.glideapps.com/t/user-specific-checklist-with-progress-status/44689/3 "2022-07-18T03:48:32Z")

</div>

Thank you for responding. That makes sense and I will give it a try. When I type in “null” in the Glide editor, will it translate that or do I need to input a special character?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 18, 2022, 3:56am UTC](https://community.glideapps.com/t/user-specific-checklist-with-progress-status/44689/4 "2022-07-18T03:56:39Z")

</div>

Just leave it empty - don’t enter anything