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

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. 🙂

Find more posts tagged with

Formulas

Accepted answers

Devin Lee

Hey @Katie F,

Try something like this.

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.