counting tasks in a project

ShaunW
ShaunW ✭✭✭✭
in Formulas and Functions

Hi i have a sheet that i am counting the number of tasks that each resource has, it works fine if only one resource is on a task but if i have multiple resources it doesn't count that task, i am using the formula =COUNTIFS({Project Schedule- Assigned To}, $[Primary Column]@row, {Project Plan- Status}, [Column2]$9), any suggestions?


image.png


· Share on FacebookShare on Twitter

Answers

  • Amit Wadhwani
    Amit Wadhwani ✭✭✭✭✭✭

    Hi @ShaunW

    You can use the HAS function for multiple contacts in cell. You an try the below formula

    =COUNTIFS({Project Schedule- Assigned To}, HAS(@cell, $[Primary Column]@row), {Project Plan- Status}, [Column2]$9)


    Best Regards

    Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

    https://www.linkedin.com/in/amitinddr/

    If my solution helped you, do not forget to mark it awesome

    Best Regards
    Amit Wadhwani    , Smartsheet Community Champion
    Smartsheet CoE, Ignatiuz, Inc., Exton, PA

    Did this answer help you? Show some love by marking this answer as "Insightful     💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/

    · Share on FacebookShare on Twitter
  • ShaunW
    ShaunW ✭✭✭✭

    many thanks that didn't quite work, if i add that statement into the string it just returns a zero

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!