Hi,
I'm currently building a timesheet app. For context, each timesheet record is being added to a SharePoint list, this means records have the same date range (as they are done weekly), etc. as each day will have several records. Hopefully, that makes sense, I have attached an image of the timesheet input screen.
I have a screen where you can view and select the timesheets you have submitted but it's obviously showing all records. I want to group these records by the date range/week so you can select the timesheet based on the week.
What I also have that is making it difficult for me to figure out how to group it, is that the timesheets have an approval status. But the records will be approved by different approvers so it means some records may be approved and others pending approval.
I have successfully grouped it by date range, please see the images attached, but as you can see this makes the status field hard to read as it lists all the statuses. Is there any way I can concise this so it will show the different statuses but won't list all the record's statuses?
Please let me know if this needs more explanation.
Thanks,
Caoimhe
