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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!