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?