Does anybody have a good idea for using SharePoint (probably calendars) instead of creating what I call 'daily planner' spreadsheets like in the screenshot I've attached below. Personally I've never been able to present a solution to an end user that they actually prefer. Typically these spreadsheets will include one worbook for each month and show what each team member is doing on a particular day. It's colour coded into categories and also allows notes. The attraction to these spreadsheets is the data input simplicity, which is normally a copy and paste once an entry of a given category exists which is first entered by selecting some cells, select a background colour and type into the (and/or) first cell / notes column. Also these spreadsheets provide end users an easy visual cue as to who is doing what on a given day.
I have tried using a SharePoint calendar, creating some columns, setting up views and enabling colour-coding based on a category column but end users prefer these spreadsheets because it gives them an easier view of what is happening on a given day and the data input takes longer.
I would like to utilise SharePoint functionality to deliver benefits such as Outlook calendar integration and concurrent editing abilities, but so far these benefits aren't enough to tempt my end users into new ways of working.
Has anybody had any success in using SharePoint for this type of 'daily planner' functionality?
Regards,
