I would like to have a Jobs Table, where I can log jobs I have done for my clients. I have a list of clients, some of which are not active. I want to be able to select a client on the Jobs Table, but only display the “Active” clients. How can I do...

Something so simple to do in Excel, but is lacking here without writing complicated formulas, and even then it won’t autosum the column as it doens’t recognise the data type. I would like to be able to enter a duration I spent on each task as HOURS:M...