The formula contains reference(s) to field(s) error in sharepoint services

Posted on 2006-05-04
Last Modified: 2013-12-24
Following the instructions in the Microsoft Sharepoint Services training book, I created a Sharepoint list in datasheet view and attempted to create a automated calculation of a column COST to create a 17.5% value of VAT in an alternative column.  The training book confirms the formulas are simular to Excel but when I try:


I receive an error message of  'The formula contains reference(s) to field(s)'

I believe this should work, could someone advise me what I'm doing wrong?
Question by:JudyBM

    Accepted Solution


    I guess you're trying to use a regular datafield and have entered the formula in the field "Default value: Calculated value". As far as I know that's not the correct way to do it.

    I suggest this:
    When you add the new column "COST" choose "Calculated (calculation based on other columns)". The formula box will appear and you can insert the columns you need to use in your formula.


    Author Comment

    Excellent.  Thank you :)

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
    When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure ( It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
    The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
    The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: : Go t…

    728 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

    18 Experts available now in Live!

    Get 1:1 Help Now