I've been tasked with re-creating the attached spreadsheet image in SharePoint, and I'm kind of stuck on where to start. Basically, I need a way to add an employee to a list, attach multiple projects to that specific employee, the hours they're allotted every month for each individual project, as well as calculating their total monthly hours from all their projects. Additionally, a way to color-code the type of project an employee is working on - currently charged (green), future charged (yellow), and potential charged (red).

My programming background is beginner/amateur level, so if there is an easier, out-of-the-box solution, I'd love to hear it. I use Nintex Forms/Workflows regularly, so I'm looking into possibly integrating those as well. This is all on being done on SharePoint 2013.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.