Counting tasks throughout the year



I'm counting how many times certain tasks has been added to the list of TO DO of the year,

Meaning for instance if one of my teams (there are 4) has added to the list of day1, task1, and task2 (a different color for every task).

My problem is that it doesnt count unless there's only one task in the cell. If for instance the team1 adds two ore more tasks to the cell, it doesnt count (Ideally i'd need to add a portion of 1, but that's another question).

How am i able to count if there are several tasks in the folder?



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!