# Task and Subtask App for single user
**URL:** https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058
**Category:** Ask for Help
**Created:** [June 18, 2020, 5:50am UTC](https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058 "2020-06-18T05:50:03Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [June 18, 2020, 5:50am UTC](https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058/1 "2020-06-18T05:50:03Z")
Hello guys,
I am trying to create an App which has Clients, Task, Reimbursement and Invoice Management for myself. I will be the only user for this App.
Right now, I am manually doing these using two different Google Sheets but since I am not very good at formulas, I am not able to link both the sheets so that, once a particular task is completed, status should automatically be changed to “Pending for Invoice”. And all the items in “Pending Invoices” per Client should be clubbed so that I can create an Invoice for that client.
I am not really able to understand how can I achieve everything that is mentioned above.
Plus I also have certain recurring tasks, sub tasks.
Can someone help me or if anyone have template for it?
Thanks
---
### Author:  [@Ofer\_Chama](https://community.glideapps.com/u/Ofer_Chama)
#### Post date: [June 18, 2020, 9:49am UTC](https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058/2 "2020-06-18T09:49:28Z")
You can start by copying Glide’s Task Tracker app and see if it’s close to what you need: [https://go.glideapps.com/app/task-tracker-template](https://go.glideapps.com/app/task-tracker-template)
Your spreadsheet should probably include at least 4 sheets - Clients, Tasks, Reimbursements and Invoice Management. To link between two sheets, make sure that there is a column in each sheet that has unique data - for example client email. You can then go to Glide’s data editor and add a relation column to link two sheets together based on that information.
To change task status automatically, you can use an if-then-else column in the data editor. Define it like this:
IF task completed THEN Pending for Invoice ELSE Task Pending
For sub-tasks you would need another sheet for sub tasks. You can link those to the parent task with a relation column.
Recurring tasks are a bit more tricky, I would need to understand the use case and when they are created in order to suggest a solution.
---
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [June 18, 2020, 9:59am UTC](https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058/3 "2020-06-18T09:59:45Z")
Thanks @Ofer_Chama for quick response. I could able to manage to link Clients to a particular task. However, I am thinking to put some “Unique ID” to my Main Tasks which can be linked to subtasks, not sure how to do it because I already have list more than 100 tasks and more than 200 subtasks.
I really liked your suggestion of using IfThenElse. I will surely do this.
Even if I create all the sheets like you mentioned, how would I add task and subtasks using single Form option?
I will create the first cut App and will show you if that can help you to explain me better.
Thanks a lot.
---
### Author:  [@Ofer\_Chama](https://community.glideapps.com/u/Ofer_Chama)
#### Post date: [June 18, 2020, 10:04am UTC](https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058/4 "2020-06-18T10:04:25Z")
For a unique identifier, you can use the Row ID column in the data editor.
I don’t think you can create both tasks and subtasks in one form, but there is a “form in a form” solution suggested in this forum which may help. It’s a two-step solution I believe.
Alternatively, you can create the task first, and then add a button in the task screen to create subtasks for it.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 18, 2020, 10:07am UTC](https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058/5 "2020-06-18T10:07:03Z")
What Ofer suggested is the way I would do it as well, but it would always require you to make the task first to make it work.
Let’s say you have a screen for a task, add a button to that screen that brings you to the “Add subtasks” screen, record the “Task” name via Columns component, then add the subtasks.
---
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [June 22, 2020, 1:51am UTC](https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058/6 "2020-06-22T01:51:42Z")
Thank you @Ofer_Chama and @ThinhDinh for your help. I could manage to add subtask exactly under the “Task” I wanted using Row Column. Thank you so much for all your help.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 22, 2020, 1:52am UTC](https://community.glideapps.com/t/task-and-subtask-app-for-single-user/11058/7 "2020-06-22T01:52:52Z")
Nice to hear it worked Pratik. Have a nice week!