I am not sure which status function to use

[crazybake]

I have a number field and also a collection of text fields. What is the proper function to use so that I can populate another field with the number in the number field + the number of text fields that have been filled in.

( i.e. there are 4 colors ordered on job two plus two of the special color fileds hve been filled in...so they order 6 colors)

[Vaughan]

numberfield +

(IsEmpty(text1) = 0) +

(IsEmpty(text2) = 0) +

(IsEmpty(text3) = 0) +

(IsEmpty(text4) = 0)

The (IsEmpty(text1) = 0) expression will evaluate to either 0 or 1 depending on whether the field is empty.