Formula to check box when a drop down has been selected AND it is a row of indent level above 1

Katie F

Hi,

I'm trying to automate a tick box when two other conditions are fullfilled. Firstly, one drop down is selected (in [Consultant Assessment] column) AND the row indent level not 0 or 1.

This is what I have at the moment:

=IF(AND(ISBLANK([Consultant Assessment]@row), ([Indent Level]@row < 2)), 0, 1)

However, it isn't picking up if a selection is or is not being made from the drop down list in the [Consultant Assessment] column.

Am I approaching this the right way? Any help, much appreciate. 🙂

Devin Lee

Hey @Katie F,

Try something like this.

=IF(AND([Consultant Assessment]@row <> "", [Indent Level]@row > 2), 1, 0)

Devin Lee

Hey @Katie F,

Try something like this.

=IF(AND([Consultant Assessment]@row <> "", [Indent Level]@row > 2), 1, 0)

Katie F

Thanks @Devin Lee - that's great. I just needed to change the indent to 1 and it's working a treat. Appreciate your help.