Formula to find non-empty value

[michael2529]

Hi All

I am trying to write a formula that essentially checks multiple fields for non-empty values and then once it finds that value, it will populate the output column. I can't seem to get the formula correct though... any thoughts or advice? Thanks in advance!

IF [item_code] = IsEmpty([item_code]) THEN [Input_#2_item_code]
ELSEiF [Input_#2_item_code] = IsEmpty([Input_#2_item_code]) THEN [Input_#3_item_code] = IsEmpty([Input_#3_item_code])
ELSEIF [Input_#4_item_code] = IsEmpty([Input_#4_item_code]) then [Input_#5_item_code]
ELSEIF [Input_#5_item_code] = IsEmpty([Input_#6_item_code]) then
[Input_#6_item_code] ENDIF

[messi007 · Accepted solution]

@michael2529,

Please try the formula below :

IF IsEmpty([item_code]) THEN [Input_#2_item_code]
ELSEiF IsEmpty([Input_#2_item_code]) THEN [Input_#3_item_code]
ELSEIF IsEmpty([Input_#4_item_code]) then [Input_#5_item_code]
ELSEIF IsEmpty([Input_#6_item_code]) then
[Input_#6_item_code] ENDIF

Regards,

[michael2529]

Perfect, thank you!