COUNT Formula for counting number of comments in another sheet

mariahneu

Hi! I am trying to figure out how to write a COUNT formula to count the number of comments in another sheet by using a cross-sheet reference.

How do you include a comment count in a Smartsheet formula?

BullandKhmer

Its not going to happen.

akrenek

Hi @mariahneu,

A work around may be utilizing the Last Comment column. Add this column to your sheet, if you don't want it visible, then I would suggest adding it to the end and hiding it once you're finished. Then you can use the =COUNT([Latest Comment]:[Latest Comment]) formula and it will count all non blank cells.

Hope this helps :)

Aleya