Total Count if value matching from multiselect cell
Please help, i have 2 sheets.
One sheet (Second picture) contains week no. i.e. the week No (depending on a date) in which a member took leave or was absent.
The other sheet (First picture): I wanted to count total week numbers from that column only if week number is mentioned in multi select cell (under Week Number Column).like for first entry it will count only if week number is 4,8,13, 17 or 21...
Tags:
Answers
-
I think you're looking for IF(CONTAINS(. Something like:
=IF(CONTAINS({Week No Lookup}, [Week Number]@row), COUNTM([Week Number]@row),0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 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!