IF/AND Statement using text & checkbox

Ok, I've got to be so close on this formula and it's probably something so simple I'm missing.

I want the cell to check the box if two criterion are met: The "In AOP" is checked, and the Status is "Temporary Replacement".

=IF(AND(FIND([Employment Status]@row, "Temporary Replacement), FIND([In AOP]@row, =1), 1, 0)

Find more posts tagged with

Accepted answers

Danielle Arteaga

I am assuming that your "In AOP" column is a checkbox column and that the column where you are placing the formula is also a checkbox column.

If that's true, this should do it:

=IF(AND([Employment Status]@row = "Temporary Replacement", [In AOP]@row = 1), 1, 0)

Not sure why you're using "FIND." Are you trying to get a summary of ALL rows that have both "Temporary Replacement" and the In AOP box checked? If so, you could create a column that uses the formula I provided, then use the worksheet summary flyout to place a COUNTIF formula for that summary.

All comments

Danielle Arteaga

I am assuming that your "In AOP" column is a checkbox column and that the column where you are placing the formula is also a checkbox column.

If that's true, this should do it:

=IF(AND([Employment Status]@row = "Temporary Replacement", [In AOP]@row = 1), 1, 0)

Kimberlee Adam

Yah it worked! That was driving nuts, I knew I was just a little off. LOL

Thank you!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.