AnsweredAssumed Answered

Field calculation that checks to see if multiple fields have data in them.

Question asked by swillette on Jan 25, 2015
Latest reply on Jan 26, 2015 by swillette

Title

Field calculation that checks to see if multiple fields have data in them.

Post

I need to create a calculation field that will check 5 container fields to see if they have or have not data in them, and then the calculation field give the number of how many of the container fields have data. For example if 3 fields have data, a 3 appears in the calculation field.

An IF statement like below could be used to check one field, but I’m not sure how to check multiple fields.

If (IsEmpty (Chart Screen Shot1 ) ; "" ; 1 )

A Case statement doesn’t seem to work. The only thing I can think of doing is maybe a Let calculation defining variables in the calculation. Any help would be appreciated.

Outcomes