Using Row Comments in a Formula

Hello!

I am currently working on a dashboard, and need to populate rows that have comments. Is there a way to do so or is there a formula I can use to indicate if a row has comments? I tried doing an IF statement, but I am not sure what the row comments would be referred to.

Any information provided is greatly appreciated!

Find more posts tagged with

Formulas

Dashboards

Comments and Conversations

Accepted answers

All comments

JamesB

@lupitafajardo I am assuming you are referring to the Conversations at the far left of the row. In order to track this in your sheet, use a workflow automation to set a value in a helper column. You can then filter your sheet based on this value.

lupitafajardo

@JamesB

Good morning! I appreciate your response, but I am not looking for a tracker. I am looking for a way to populate comments from rows in a sheet into a Dashboard or a column formula to use to indicate if a row has comments.

Thanks!

JamesB

@lupitafajardo

Can you provide a screenshot of what information you are wanting. I am not sure I am understanding completely. Are your comments in a cell in the sheet, or are you referring to the conversations option on the far left of the row?

If it is comments in a cell, you should be able to use a report and filter out the comment cells that are blank. If you are only looking to indicate the row has comments then the suggestion I originally made would not be a tracker, it would create a way to indicate rows that have comments on them so you can filter the rows based on the helper column.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.