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
 63.7K Get Help
 405 Global Discussions
 216 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!