Suggestion — Add a formula to retrieve information about the comments in a row

It would occasionally be useful to be able to access information about comments within a formula. For instance:

IF(CountRowComments() gt 0, "Has comments!", "No comments")

Or even,

IF(GetComment(1).Contains('error'), TBD, TBD)

(Don't take the syntax too literally, but hopefully you get the idea.)

Find more posts tagged with

Formulas

functionality

Comments and Conversations

Comments

Andrée Starå

Hi,

Great idea! That would be a great addition to Smartsheet features.

Please submit an Enhancement Request when you have a moment

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Colleen Maciejewski

I would like to see a change to the approval process where I have a third option of "Need more info", and the system would insert at @email in the comments areas to tag the requester. Is there another way of doing this in Smartsheet via a formula instead? I've been digging, but no luck so far. Many approvals require a back and forth exchange of info, and I think it would be nice if those emails were self documenting.

Andrée Starå

Hi @cmaciejewski

Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could maybe use the comment feature in the Approval, and then that would register as a "Need more info" option and go from there.

What do you think?

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto