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

Posted on 2006-05-04
Medium Priority
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

zyndertin earned 500 total points
ID: 16683026

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

ID: 16733159
Excellent.  Thank you :)

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
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…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

807 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