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

05/06/20

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

Comments

  • Andrée Starå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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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å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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.