Simple project request form
I am an intern at a small company (10-15 people) who has been tasked with researching a free way to submit and track projects and project requests for myself (media intern), and possibly other interns in the future. The goal is that everyone doesn't have to go through the person managing me to ask for my help with something, and that there's a document that anyone working over me can check to see what I'm working on, how much I'm working on, and if I have more stuff laid ahead to keep working on. I'm thinking of doing it with a Google form and Google sheet because I'm relatively familiar in those areas.
My main question is: is there a way to sort the project information onto different parts of a sheet? Like a tote sensitive section and a not time sensitive section? Or to sort responses in decending order of due date?
Also is there a way you would recommend differentiating between projects that have been submitted and projects that we've accepted or projects that I'm working on?
(I know this is not the perfect project management option, I am already looking at alternatives also, please no comments about using other services instead)