Conditional result based on if Fields are empty, partially, or not empty.

[emtau]

So I have 3 text input Fields and 1 Status (Calculation) Field. 

I want the Status Field to calculate if: all the 3 text fields are empty it will output "Pending", if one or two text fields are not empty it will output "In Progress" and if all 3 text Fields are not Empty then will output "Completed".

How can I go about doing this? I tried a few Case and If statements and always end up only between "Pending" and "Completed" as a result and couldn't get the "In Progress" result.

A little light on this would really appreciate it. Thank you.

[comment]

You did not tell us the names of the 3 input fields; here I will use InputA, InputB and InputC:

Let (
n = Count ( InputA ; InputB ; InputC )
;
Case (
n = 3 ; "Completed" ;
n > 0 ; "In Progress" ;
"Pending"
)
)

Make sure to uncheck the "Do not evaluate if all referenced fields are empty" option.

 

[emtau]

Thanks alot this works very well