B i t s O f S h a r e P o i n t C o n s u l t i n g L L C > B l o g P o i n t > Posts > Calculated Column - Formula - Yes/No Field

12/12/2008

Calculated Column - Formula - Yes/No Field
OK, so I was trying get a formula in calculated column to recognize the Yes/No field (check box), this is not the choice field.  You would think that you could check to see if the filed is yes or no, but that turns out not to be the case.
 
I read a few posts and the data is stored in Boolean, so I tried 1 or 0 as some post said, but that did not work.  I then stumbled upon a post that said to use True or False, that worked.
 
Here is an example: 
 
WORKED:
=IF(Attending=TRUE,"Attending","Not Attending")
 
Did NOT work:
=IF(Attending="Yes","Attending","Not Attending")
=IF(Attending=1,"Attending","Not Attending")
 
 
Posted at 1:36 PM by Peter Allen | Category: SP-Calculated Columns - Formula; SharePoint | Permalink | Email this Post | Comments (4)

Comments

Calculated serial number column

Hi,

Can I have a serial number generated automatically when a new item is added or a new document is uploaded in a list/library? For example, first record is added it should be abc/xyz/1, then next time abc/xyz/2 and so on

Regards,
Manu
at 6/25/2009 5:55 AM

very helpful, thanks!

very helpful, thanks!
at 10/15/2009 6:25 PM

RE: Calculated serial number column

To do this you could use a Workflow to accomplish it.  I am not aware of a solution out that does this.
Peter Allen at 11/13/2009 10:50 AM

THANK YOU

Thank You!!!
at 5/10/2010 3:00 PM

Add Comment
Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


Addition: 2 + 1 = *


Please complete this equation.

Email


This is optional.
Attachments

 T o p i c P o i n t

 E x a m p l e P o i n t