How can we use multiple conditions in a formula?

[anjali]

I want three conditions to be fulfilled SQ No & SQ Amount is not Blank & SQ Sent is unchecked

Here last SQ Sent Column type is check box.

I want to filler out data where all these conditions are met.

[rachitk]

Here’s the formula you can use:

IF({SQN}=BLANK() && {SQA} = BLANK() && {C} = "unchecked", "TRUE","FALSE")

Here’s how the table and output will look like:

You can then filter out ‘True’ status in another view. So only those records will be visible in that view.