Appsheet Expression Combining IF, OR, AND and ISBLANK statement

AppSheet AppSheet Q&A
1

Hi Team,

Appsheet novice here, wondering if you can help me out.

I’m trying to make an expression that checks for blanks in multiple fields but using two different criteria and then combining the results. For the first set of fields I want to know if any fields are blank:

HouseNumber
Street
ZipCode
City
State

For the second set I want to know if all the fields are blank.

Age
Weight
Height
HairColor
EyeColor

I then want combine the two expressions into one and if they are both true then it returns a yes or wise no?

Any ideas. Thanks.

2 
AND(
    OR(
       ISBLANK([HouseNumber]),
       ISBLANK([Street]),
       ISBLANK(etc),
       ISBLANK(etc),
       ISBLANK(etc)
   ),
   AND(
       ISBLANK([Age]),
       ISBLANK([Weight]),
       ISBLANK(etc),
       ISBLANK(etc),
       ISBLANK(etc)
  )
)

It would be like the above. Insert the proper column names where “etc” appears.

NOTE: That “Yes”, “Y”, “TRUE” can all be used interchangeably…

“No”, “N”, FALSE can all be used interchangeably

I

1 Like
3

Thanks WillowMobileSys