Multi-Field Formula--If multiple columns IsEmpty then populate those fields with new data

[vujennyfer]

Hello, 

I'm trying to check existing address fields and bring in new data ONLY if all of the existing address fields are null/empty. Would the multi-field formula be the best option for this case or is there another tool? 

This is what I am trying to accomplish and I've also attached the workflow: 

IF IsEmpty([address_1]) AND IsEmpty([address_2) AND IsEmpty([city]) AND IsEmpty([state]) AND IsEmpty([zip])

THEN [n_address_1] AND [n_address_2] AND [city] AND [state] AND [zip]

ELSE [_CurrentField_]

ENDIF

[markcurry · Accepted solution]

Hi @vujennyfer , if you are just looking to bring in the rows with no information in any of the data fields, I think a Filter would work, just using the Custom filter option, with the formula ...

IsEmpty([address_1]) AND IsEmpty([address_2]) AND IsEmpty([city]) AND IsEmpty([state]) AND IsEmpty([zip])

Hope that helps, Mark 

[vujennyfer]

Thanks Mark! I was definitely over complicating it 🙂