In a multiple option cell counting how many options selected.
Stevey C
✭✭✭✭
In a form linked to a request tracker I have dropdown multiselects, one of these has 30 of which and number may be required.
I would like to calculate the number of tasks needed for use in a complexity calculation used when determining whether a template should be used or into a dashboard for employee workload..
Best Answer
-
Hi, my apologies I resolved it very simply using COUNTM and forgot to update.
Answers
-
Hi @Stevey C Could you post an image of your sheet (removing anything that should not be publicly visible) and an example of the calculation you are trying to do? That would make it easier to understand the problem.
-
Hi, my apologies I resolved it very simply using COUNTM and forgot to update.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!