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

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Autonumber Not Working
Hi, We I use the edit column properties and select autonumber, the sheet no longer generates a number. Please help.