?
Solved

Sharepoint Formula

Posted on 2006-06-12
4
Medium Priority
?
597 Views
Last Modified: 2009-06-15
I am trying to make a formula in sharepoint that consists of the following.  One of the columns used in the formula is a yes or no check box.  Another is a date.  If the first box is checked yes then the formula should consist of the date box plus 4 days.   How can I wirte this formula?
0
Comment
Question by:davelalande
[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
  • 3
4 Comments
 
LVL 22

Expert Comment

by:_TAD_
ID: 16896549
SharePoint formulas are very similar to Excel spreadsheet formulas.

Suppose you have two other columns called isTrue and someDate

[isTrue] = true/false
[someDate] = date field

IF([isTrue] = "true", [someDate]+4, [someDate])



... I am also fairly certain that the [isTrue] = "true" is case sensitive.  So 'True' is different than 'true'.
0
 
LVL 22

Expert Comment

by:_TAD_
ID: 16896559
FYI...


You'll get better/quicker responses if you post your SharePoint questions here:
http://www.experts-exchange.com/Networking/Sharepoint/


I'm not sure how the mods came up with the navigation, but there is indeed a SharePoint TA.
0
 

Author Comment

by:davelalande
ID: 16896715
here is a better example of what i am trying to do....

one column is named recision and it is a checkbox......

then other column is named begin and it gives a date....

the column i am trying to make is a recision date, it is only to be available if the recision column is checked off.  When it is checked off then this column should constist of a formula that sais [begin]+4.....

I need to know how to attatch the recision and recision date so when the check box is checked then the recision date pops up.
0
 
LVL 22

Accepted Solution

by:
_TAD_ earned 150 total points
ID: 16897706
If I understand you correctly, you can't do that.

SharePoint does not support conditional column visibility.  All columns are visible all the time.  

You can have the following:

A column called Recision (yes/no)
A column called Begin (date)
A column called Recision Date (formula - type date returned)

ALL VISIBLE


recision date formula:   =IF(recision=TRUE,begin+4,"-N/A-")


0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

If you want to move up through the ranks in your technology career, talent and hard work are the bare necessities. But they aren’t enough to make you stand out. Expanding your skills, actively promoting your accomplishments and using promotion st…
Stuck in voice control mode on your Amazon Firestick?  Here is how to turn it off!!!
The Bounty Board allows you to request an article or video on any technical topic, or fulfill a bounty request to earn points. Watch this video to learn how to use the Bounty Board to get the content you want, earn points, and browse submitted bount…
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.
Suggested Courses

770 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