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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!