Solved: use and and or in the same formula - Page 2

fvaluch · 01-28-2022 02:23 PM

Hello everyone, I hope you are very well.

I wanted to request help to find the formula that solves my problem in Appsheet.

I need to fetch all the results of the sub_date column when it is not empty, and I need to fetch all the results of the state column when it has the following values: analysis, docs and when the field is empty.

It is worth clarifying that the state column has several types of extra values, which do not interest me in the formula either.

fvaluch

Hello, sorry for the delay, this was the solution to the problem.

AND(
ISNOTBLANK([sub_DATE]),
OR(
ISBLANK([STATE]),
IN([STATE], {"ANALYSIS", "DOCS"})
))

View solution in original post