Solved

Sharepoint list calculated column value based on checkbox

Posted on 2013-01-24
1
2,365 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 250 total points
ID: 38817508
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

707 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