Formula to capture a total amount of items in a cell.
I am looking for a formula that will give me the total number of items listed under benefits for a project.
For example, =COUNTM([Project A]:[Project A], Benefits:Benefits])
We currently have 17 benefits that can be selected in each project. I this particular project, only 2 benefits apply.
Best Answer
-
To get the count of items in the benefits cell for each row, you just need:
=COUNTM(Benefits@row)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
How is your data structured? Does each Project have its own row? Is the Benefits column a multi-select column?
With your current formula, if both Project A and Benefits are multi-select columns, COUNTM will count the total number of choices selected in both columns. So if you have values of Project A1, Project A2, and Project A3 selected, and each has 4 different values selected in Benefits, your formula would return 15 - that is, 3 from the Project A column and 12 from the Benefits column.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
This is how my data is structured. Yes, each project has its own row. The benefits column is a multi section column.
-
To get the count of items in the benefits cell for each row, you just need:
=COUNTM(Benefits@row)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
That worked! Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!