Creating a filterable table for a Responsibility assignment matrix

Creating a filterable table for a Responsibility assignment matrix

Hello,
I'd like to create a filterable table showing who is responsible for a specific task in the organization.

I imagine the following columns:
- employee name
- employee task
- substitute (the person who will substitute that person on that task if the main responsible is not present)
- frequency (what is the frequency of the task)

The table should be segmented by Department. So it has to be something like this (row 1 is an header, row 2 is a segment header):

EMPLOYEE NAME | EMPLOYEE TASK | SUBSTITUTE | FREQUENCY
ADMINISTRATION DEPARTMENT ----------------------------------------
John Smith               | Pay the bill             | James Dean   | Monthly
John Smith               | Upload invoices     | James Dean   | Weekly
Tory Spelling            |  Call customers      | John Smith     | Daily
IT DEPARTMENT ------------------------------------------------------------
John Halloway         | Creating backups  | Mark Gates    | Weekly

etc.

Each column will be filterable by text.

Also: I'd like to give the ability to employees to add their own tasks by filling a form.

Is there any Zoho One solution I can use to create something like this? 
Thank you


      • Sticky Posts

      • Connect with Zoho users from your industry, virtually!

        A couple of years ago, we started setting up industry-wise channels for users with similar businesses to chat and discuss Zoho contextually. We started with Real Estate and E-commerce sectors, creating a chatroom and hosting regular meetups on niche areas

      • Feature update: Advanced security settings

        We've previously written about how using security policies could be beneficial for admins. To enable you to better protect your organization, we've come up with a few additional settings for security policies in Zoho One that can be used to regulate your users' web sessions. What are web sessions? A web session refers to the period of time you stay signed in to your Zoho One account. You create a new web session every time you sign in to Zoho One (or any of its included apps), and this session exists