Solved

Sharepoint Formula

Posted on 2006-06-12
4
589 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Phishing is at the top of most security top 10 efforts you should be pursuing in 2016 and beyond. If you don't have phishing incorporated into your Security Awareness Program yet, now is the time. Phishers, and the scams they use, are only going to …
Digital marketing agencies have encountered both the opportunities and difficulties that emerge from working with a wide-ranging organizations.
Saved searches can save you time by quickly referencing commonly searched terms on any topic. Whether you are looking for questions you can answer or hoping to learn about a specific issue, a saved search can help you get the most out of your time o…
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.

863 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

26 Experts available now in Live!

Get 1:1 Help Now