Solved

Sharepoint list calculated column value based on checkbox

Posted on 2013-01-24
1
2,167 Views
Last Modified: 2013-02-04
Hi,
I am trying to add a formula to a calculated column I created in my Sharepoint list.  If the user checks my checkbox column then the calculated value is based on another field * some numbers, if not then the value is just 0.  Here is my syntax:

IF([Material Delay],([Labor (Hours)]*66)*.50),0)

Keeps saying my syntax is wrong or it is not supported.  Not sure what I'm doing wrong.
0
Comment
Question by:imstac73
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 250 total points
Comment Utility
Hi,
yes, there is an error in your formula - you are missing one opening "(" (or you have one closing ) to much).

Your formula should either be
=IF([Material Delay],(([Labor (Hours)]*66)*0.5),0)

Open in new window

or
=IF([Material Delay],([Labor (Hours)]*66*0.5),0)

Open in new window


Textual:
IF Material Delay is checked, then take the number from Labour(hours) and multiply with 66 and multiply with 0.5 else its 0.
Or you can shorten it to x*66*0.5 == x*33

HTH
Rainer
0

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

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
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.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

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

13 Experts available now in Live!

Get 1:1 Help Now