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

BullandKhmer

See, it didn't happen

Genevieve P.

Hi @mariahneu

There currently isn't a way to use a formula to look at the Conversations tab (with comments) to check values or see the number of comments made.

@akrenek's idea of using the Last Comment column is a good one if you want to count how many rows have a comment in general! You could just change the in-sheet reference to be a cross-sheet reference:

 =COUNT({Latest Comment Column})

See: https://help.smartsheet.com/articles/2482475-latest-comment-column

If you were referring to a general Text/Number column and comments you add there, you can use the same COUNT function but point it at that column instead.

Cheers,
Genevieve