Including 'check box' data in a formula

Options

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

Best Answer

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

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!