Tuesday, August 9, 2011

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

In this post we will discuss how to resolve error: 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 which comes in SharePoint 2010.

Also you can check out my previous posts on:

- Add jQuery in visual web part in SharePoint 2010

- Get icon for different file types in SharePoint 2010

- New Embed Code in SharePoint 2013

Recently I was trying to add a custom site column of type Calculated in SharePoint 2010. So in the formula box I have given like =TEXT(ParentDate,"dd-mmmm-yyyy") where ParentDate is the coulmn name and is of type date time. I have checked this formula from google. When I click on OK, it shows me the error as "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".

After that I have modified the formula to =TEXT([ParentDate],"dd-mmmm-yyyy"). The only modification I have done here is, I have added square bracket before the ParentDate and it worked for me.

No comments:

Post a Comment