Count nonblank cells in a row
Hello,
My smartsheet tracks document reviews and approval. I'm trying to create a formula that returns the number of review rounds per document, by counting "resubmission due" cells if they are not blank. I tried this formula for the first two rounds as a test, but the result is only "1" despite two cells being populated: =COUNTIFS([Resubmission 01 Due]@row, <>"", [Resubmission 02 Due]@row, <>"")
Does anyone know what I'm doing wrong?
Thank you!
Best Answer

Hey @Dana G
The formula is counting the instances that both Resubmission 01 and Resubmission 02 are not blank. One approach to remedy this is to have two COUNTIFS and add them together.
=COUNTIFS([Resubmission 01 Due]@row, <>"")+ COUNTIFS([Resubmission 02 Due]@row, <>"")
Will this work for you?
Answers

Hey @Dana G
The formula is counting the instances that both Resubmission 01 and Resubmission 02 are not blank. One approach to remedy this is to have two COUNTIFS and add them together.
=COUNTIFS([Resubmission 01 Due]@row, <>"")+ COUNTIFS([Resubmission 02 Due]@row, <>"")
Will this work for you?

Aha! Thanks @Kelly Moore that did the trick!
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
Check out the Formula Handbook template!