How can I tick a box based on two criteria?

I'd like to tick a checkbox based on another checkbox being ticked and for a specific task name. I have the following formulas that work individually. How can I combine them?

=IF([Checkbox]@row = 1, 1,0)

=IF([Task name]@row = "XYZ", 1,0)

Find more posts tagged with

Reports

Cell linking

Accepted answers

Stephen Everiss

I think I found my own answer - FYI for anyone who has the same query:

=IF(Checkbox@row = 1, IF([Task Name]@row = "XYZ", 1, 0))

Nick Korna

Hi @Stephen Everiss,

Your formula would look like this:

=IF(AND(Checkbox@row = 1, [Task Name]@row = "XYZ"), 1, 0)

Sample:

Hope this helps, but if you've any problems/questions then let us know!

All comments

Stephen Everiss

I think I found my own answer - FYI for anyone who has the same query:

=IF(Checkbox@row = 1, IF([Task Name]@row = "XYZ", 1, 0))

Nick Korna

Hi @Stephen Everiss,

Your formula would look like this:

=IF(AND(Checkbox@row = 1, [Task Name]@row = "XYZ"), 1, 0)

Sample:

Hope this helps, but if you've any problems/questions then let us know!

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.