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

Access your files securely from anywhere

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Antonio
Abhishek - Zoho Partner

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