2 Replies Latest reply on Jan 25, 2012 10:16 AM by NickPinchbeck

    formula for recognising multiple blank fields

    NickPinchbeck

      Title

      formula for recognising multiple blank fields

      Post

      Hi there,

      I am new to this product, and have spent a lot of ours figuring out how to use it. There is one thing i cannot seem to figure out so i would appreciate anyones help on it! I am using the following formula to indicate whether all of the mandatory fields in an application form are completed. If there are any of the mandatory fields that are incomplete it should appear "Incomplete", if they are all complete it should appear "complete". Here are some of the formula i tried.. and failed!:

      If(IsEmpty (Field 1 or Field 2 or Field 3 or Field 4 or Field 5 or Field 6); "Inpcomplete" ; "Complete")

      Case ( IsEmpty ( field ) ; "Incomplete" {; IsEmpty ( field ) ; "Incomplete" ; … ; defaultResult} ) 

       

      The default result would be Complete i guess...

       

      Does anyone have a soloution to this?