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

swehba

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.)

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

✅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!