AnsweredAssumed Answered

formula for recognising multiple blank fields

Question asked by NickPinchbeck on Jan 25, 2012
Latest reply on Jan 25, 2012 by NickPinchbeck


formula for recognising multiple blank fields


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?