Including 'check box' data in a formula



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")

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!