COUNTIFS to include cells with text
Options
Rochelle_B
✭✭✭
I need to create a crosssheet formula that counts the number of entries for a month and if there is text in another column.
I've come up with the formula below, but I get an Incorrect Argument error:
=COUNTIFS({Review Month}, =1, ISTEXT({Critical 1}))
Where am I wrong here?
Tags:
Comments

Try this, just need to update formula for cross sheet.
=COUNTIFS([Review Month]:[Review Month], =1, Critical:Critical, <>"")
=COUNTIFS({My Test Sheet2 Range 1}, =1, {My Test Sheet2 Range 2}, <>"")

A GODSEND YOU ARE! Thank you!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 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!