How to setup different calendar views in sharepoint.

Posted on 2014-08-06
Last Modified: 2014-11-19

I would like to setup different views in a group calendar, that has multiple users in this. It default to the week view but I would also like to have the month and year view as well.

I have followed this article ( as was suggested from other question)
I am getting an error when entering the formula

I put in the Column name
Select = Calculated (calculation based on other columns)
Then I enter the following formula in the formula field
=DATE(YEAR([Due Date]), MONTH([Due Date]), 1)
Then I select Date and Time and then date only
Unselect add to all content types
When I click OK. I get the following error message
"Sorry, something went wrong

The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.

I can click on the x to close the window.

I see the article refers to Sharepoint 2010 ( Ithink). I am using Sharepoint 2013
Question by:rha_mtl
    LVL 9

    Expert Comment

    Try creating a new column of Date/Time data type and name it 'Date'.
    Once you have created this column you can delete it.
    Try your formula again. Sometimes this will resolve your problem.
    LVL 9

    Accepted Solution

    Are you changing the column in SharePoint List Settings or are you using SharePoint Designer or InfoPath to change any of the list properties.  If so these tools could cause problems if you are editing the list in both.

    Also,  If you have access to Central Administration you might want to confirm that Sharepoint is fully patched and up to date. SharePoint does start to behave erratically if the database is in an inconsistent state or the last update did not succeed.  You can verfiy both by going to Central Admin:

    1. 'Upgrade and Migration|Review Database status' All content database should have a status of 'No action required'

    2. 'Upgrade and Migration|Check Upgrade Status' Status of last upgrade should be 'Succeeded'

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
    We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now