COUNTIFS criteria is CELL+anything
Hi,
I've created a rather complicated cross-sheet formula that counts cells from a different sheet using 3 criterias. One is the description that starts with a text mentioned in a cell above. I've tried to enter the search criteria into the formula like this
=COUNTIFS({Other sheet Range 1},$Column$14 & * , ...)
=COUNTIFS({Other sheet Range 1},$Column$14 & "*" , ...)
=COUNTIFS({Other sheet Range 1},$Column$14 + * , ...)
=COUNTIFS({Other sheet Range 1},$Column$14 + "*" , ...)
None of them worked, what am I missing here? Is there a different "anything" variable used in smartsheet?
Best regards
Alex
Comments
-
try this
=COUNTIFS({Other sheet Range 1}, LEFT(@cell, LEN($Column$14)) = $Column$14...)
-
That worked perfectly well, thank you so much!
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
- 146 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!