Solved

Sharepoint Formula

Posted on 2006-06-12
4
588 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
  • 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 50 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Learn more about the importance of email disclaimers with our top 10 email disclaimer DOs and DON’Ts.
I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
Articles on a wide range of technology and professional topics are available on Experts Exchange. These resources are written by members, for members, and can be written about any topic you feel passionate about. Learn how to best write an article t…
Where to go on the main page to find the job listings. How to apply to a job that you are interested in from the list that is featured on our Careers page.

757 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

21 Experts available now in Live!

Get 1:1 Help Now