Expose the Last Row Comment - Bridge

With Bridge you can find a row’s latest comment and bring that information into a cell in the same row in Smartsheet. 

Who can use this?

Plans:

  • Bridge by Smartsheet

This can be useful when you use Smartsheet to summarize the overall status of active projects or jobs and ensure that you always look at the latest status left in a comment.

  • Workflow trigger: Smartsheet - When Comments Are Added
  • Templates used: Bridge - Expose Last Row Comment

Ensure that your sheet has a text column titled Last Row Comment. You can also follow the Optional Setup instructions to change which column the workflow updates.

Step 1: Deploy the template

  1. In Solution Center, find the template Expose Last Row Comment and select it.
  2. Give your workflow a name.
  3. Select Deploy.
  4. Select the workspace where you want to save the workflow.

The workflow template will appear in your workflow builder. Open it and customize it according to your needs.

Example sheet to Expose the last comment row worfklow

Step 2: Set up the workflow trigger

  1. Select the Trigger element at the start of the workflow.
  2. Under the Integrations section, select Integrations Page.
  3. Find Smartsheet and select it.
  4. Once authenticated, select the Triggers tab and expand the Triggers.
  5. Select Add to Triggers.
Example sheet to Expose the last comment row worfklow

  1. In the Sheet ID field, enter the unique sheet ID. If you know the sheet name is unique, you can type in the name.

    Find the sheet ID by navigating to your sheet and selecting File > Properties.
     

  2. Select the Event Type: When Comments Are Added.
  3. Select the workflow that should be triggered from the dropdown.
  4. Select Save and return to the designer in the original tab.

Step 3: Optional setup

Set the comment column name

If you’re not using the Smartsheet template, or you want to rename the comment column in the sheet you’re using, set the name of the column that should receive the comment text in the workflow:

  1. Select the Update Row module in the workflow.
  2. Expand the Cells section. 

  3. By default, the Key #1 field is set to Last Row Comment. Change it by typing in the column name where you want to expose the last comment.

    Ensure to spell it exactly as you do on your sheet.

  4. Select Save.

Test the workflow by navigating to your sheet and entering a comment on any row. The comment should appear in the specified column on the same row. 

You can also see the workflow trigger and the steps executed in the Run Log.

Reformat the last comment posted 

The workflow can also add information about the user who commented and when they did so. If you don't want to show this information or you want to change it, select the Compose Text module in the workflow. In the Enter Text field, you can format what appears in the cell.

By default, it references the comment text, the commenter's email, and the timestamp for when the comment was made. This data is brought into the workflow by the Get Comment module. If you run the workflow once, you can copy references to any other information you want to include via the Run Log module.

Date format in the posted comment

You can change the timestamp format by selecting the Format Date/Time module.

Example sheet

The screenshot below shows the sheet used when building this example. 

The column Last Row Comment is used in this workflow, so if you want to create this example, ensure you have a column with the same title in your sheet, too.

Example sheet to Expose the last comment row worfklow