Why is this formula not working?

Why is this formula not working? For the life of me works in excel.


=COUNTIFS({Network Security Projects Range 1}, [NetSec Group]2, {Network Security Projects Range 6,"Arlyssa Jaquez"})

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @David Rice ,

    Try this:

    =COUNTIFS({Network Security Projects Range 1}, [NetSec Group]2, {Network Security Projects Range 6} ,"Arlyssa Jaquez")

    There was a } out of place. Beyond that confirm that when you click on the formula [NetSec Group]2 highlights. If you still get an error we'll go to the next step.

    Good luck,

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!