COUNT Formula for counting number of comments in another sheet
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?
Answers
-
Its not going to happen.
-
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
Aleya Krenek
Education Service Center Region 13
Grants and Contracts Project Coordinator
-
See, it didn't happen
-
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:
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!