Including 'check box' data in a formula

hello

I'm trying add the total IT hours in a project. I added column into my plan and checked all the resources classed as IT. When I ran the below formula it is not picking up the 2000+ hours and instead is giving me 0. Any advice where I am going wrong? thank you!

The Infor Nexus IT Team in the column that contains all checked IT resources.

=SUMIFS({Infor Nexus Effort Hours}, {Infor Nexus IT Team}, "IT", {Infor Nexus Status}, "In Progress")

Find more posts tagged with

Accepted answers

Heather Duff

Hi @Bijal Shah ,

Try this:

=SUMIFS({Infor Nexus Effort Hours}, {Infor Nexus IT Team}, 1, {Infor Nexus Status}, "In Progress")

When you're searching for a checked box, the value is 1 for checked, or 0 for unchecked.

Let me know if it works!

Best,

Heather

All comments

Heather Duff

Hi @Bijal Shah ,

Try this:

=SUMIFS({Infor Nexus Effort Hours}, {Infor Nexus IT Team}, 1, {Infor Nexus Status}, "In Progress")

When you're searching for a checked box, the value is 1 for checked, or 0 for unchecked.

Let me know if it works!

Best,

Heather

Bijal Shah

THANK YOU SO MUCH! it works a dream :)

Bijal Shah

Heather Duff

Glad it worked! :)

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.