[Last Call] Learn how to a build a cloud-first strategyRegister Now


How to setup different calendar views in sharepoint.

Posted on 2014-08-06
Medium Priority
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
  • 2

Expert Comment

ID: 40301179
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.

Accepted Solution

macarrillo1 earned 1000 total points
ID: 40309974
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month17 days, 18 hours left to enroll

830 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