locked
Calculation for field in document library RRS feed

  • Question

  • I'm trying to write a formula for a calculated field in Sharepoint Designer 2007.  Can anyone help me?  Here is the long-hand version of what I want.

    Field Name = Level

    If Level 1 = true, Level = 1

    If Level 2 = true, Level = 2

    If Level 3 = true, Level = 3

    If Level 4 = true, Level = 4

    If Level 5 = true, Level = 5

    Does anyone know what the formula would be for this calculated field?

    Friday, June 24, 2016 7:30 PM

All replies

  • Hi,

    Can you elaborate little more on your questions, Level 1 is what, is you have other columns with name Level 1, 2, 3 4



    KRISHANA KUMAR

    SharePoint Architect

    Mosstechnet-kk.com

     

    Please click "Mark As Answer" if this post solves your problem or "Vote As Helpful" if it was useful

    Friday, June 24, 2016 8:15 PM
  • Got it....thanks for trying.  I didn't know the IF statement formatting but finally found something that helped me.  This was the formula that worked:

    =IF(Level1="true","1",IF(Level2="true","2",IF(Level3="true","3",IF(Level4="true","4","5"))))

    Monday, June 27, 2016 12:31 PM