Applies to

Bridge by Smartsheet

Schedule daily sheet save

Save your sheet daily and update the TODAY function in your sheet, with no need to open or edit the sheet.

Who can use this?

Plans:

  • Bridge by Smartsheet

The TODAY function in Smartsheet returns the current date within formulas. However, for the TODAY function to recognize the current date, you must update and save the sheet. If the sheet doesn’t have enough daily activity for TODAY to update, this Bridge workflow can automatically do that for you each day.

When this workflow runs, it grabs the current status of the Save Sheet column. Then, to cause a change in the sheet and force the sheet to save, it selects or clears the box. Once those changes are applied and saved, the workflow updates the TODAY formula.

What you need to get started

  • A sheet:
    • The sheet ID
    • A checkbox column named Save Sheet
    • The row ID for a row that will always stay on the sheet
  • Bridge:
    • Smartsheet integration
    • Bridge Schedule trigger
    • Bridge Workflow modules:
      • Smartsheet - Get Row
      • Smartsheet - Update Row
      • Conditional Junctions - Match Junction
      • States

Get started

To build this workflow in Bridge, authenticate the Smartsheet integration for your Bridge workspace. See how to set up the Smartsheet integration for Bridge

While building your workflow, keep your sheet and your Bridge workflow open in two separate tabs. This makes navigating the build process easier!

1. Create a hidden field

  1. In the sheet you want to save on a daily basis, add a column and name it Save Sheet. 
  2. Make it a checkbox type of column. 
  3. Check the box on your selected row.
  4. Hide the Save Sheet column.
  5. Save the sheet.

You’ll only be using one row in the column for your workflows. So, choose a row that makes sense to your process and that you know won’t be deleted. It won't interfere with any other columns on the same row.

2. Construct the basic workflow model

Before everything else, pull all the modules you need for the workflow. 

  1. Create a new workflow in Bridge
  2. In the workflow builder, use the panel to add modules in this order:
    1. Integrations > Smartsheet: Get Row
    2. New Junction: Label it Check Box Value. Label one state Clear Box and the other one Select Box
    3. Integrations > Smartsheet: Update Row. You need two of these modules, one under each Junction path.
  3. Save the workflow.

This is what you should see in your workflow when you are done:

Brandfolder Image
Adding Match Junction

3. Set up the workflow modules

Step 1: Set up the Get Row module

You have to manually enter values in the Get Row module. Then, fill out the remaining modules, use runtime (Run Log) data references from the Get Row results.

  1. In the Sheet field, enter the sheet ID
  2. In the Row ID field, enter the row ID
  3. Save the workflow. 
  4. Open the Run Log, on the right pane.
  5. To run the workflow, select Play Play icon.

What does the Get Row module do in this workflow?

The Get Row module pulls data from the row and pushes it into the workflow's Run Log.  From the Run Log, you can reference data in the next stages of the workflow.

Step 2: Set up the Junction Match module

  1. Open the Run Log
  2. To see the test run created when you selected the Play button, refresh the Run Log.

    The Run Log entry will say Stopped. That's expected because you haven't yet completed the setup.

  3. Locate the data references needed. 
    • Expand the Smartsheet: Get Row line. 
    • Expand the row: Object line. 
    • Expand the cells: Object line. 
    • Locate the Save Sheet column entry from the list of sheet columns. Then, expand the entry. 
  4. On the right side of the value entry, select More Options icon.
  5. Select Copy data reference.  
  6. Open the Junction: Match module. 
  7. In the First Value field, paste the reference you copied.
  8. In the Second Value field, type true.
  9. Save the workflow. 

This is what you should see in the Junction Match module when you’re done:

Brandfolder Image
Setting up Junction Match Module

What do the Junction Match modules do in this workflow?

The Junction Match module analyzes the Save Sheet column data from the Get Row module results, to determine whether the Save Sheet column box is checked or not. If the box is checked, the Junction Match module follows the Clear Box path. If the box is unchecked, the Junction Match module follows the Select Box.

Step 3: Set up the Update Row modules

  1. Get the sheetId value from the Smartsheet: Get Row module.
    1. Reopen the Run Log.
    2. Locate the sheetId value from the Smartsheet: Get Row data.
    3. Copy the data reference.
    4. Open the Update Row module.
  2. Get the id value from the Update Row module.
    1. Return to the Run Log.
    2. Locate the id field.
    3. Copy the data reference. 
    4. Open the Update Row module.
    5. In the Row ID field, paste the reference.
  3. In the Uncheck Box path of the Update Row module, follow these steps: 
    1. Expand Cells
    2. In the Key #1 field, enter the column name Save Sheet
    3. In the Value #1 field, type false.

      In a checkbox column, false clears the box.

  4. In the Check Box path of the Update Row module, use these steps:
    1. Expand Cells
    2. In the Key #1 field, enter the column name Save Sheet
    3. In the Value #1 field, type true.

      In a checkbox column, true checks the box.

  5. Save the workflow.

This is what you should see in the Update Row modules when you are done:

Brandfolder Image
Setting Update Row modules

What do the Update Row modules do in this workflow?

The Update Row modules check or uncheck the box in the Save Sheet column, to force a change to the cell and a sheet save.

Step 4: Test the workflow

To ensure the workflow is running and taking the right actions, test both conditions. Before you start, check if the Save Sheet column in your sheet row is checked.  

  1. Open the Run Log . 
  2. Select Play Play button
  3. Go back to the sheet.
  4. Wait until the checkbox clears in your row. 
  5. Once the checkbox clears successfully, return to Bridge. 
  6. Play the workflow again. 
  7. To see the box become selected again, return to the sheet. 

Now you’ve seen both workflows complete their actions successfully. It’s time to set up the trigger to run the workflow on a daily basis. 

If the workflow isn’t running as expected, go through each step of the setup again. Make sure every field and data reference appear as directed.

4. Set up the workflow trigger 

  1. In the workflow builder, select the Trigger module. 
  2. Expand the Schedules panel. 
  3. Choose Add a new schedule.
  4. Choose a time to run the workflow each day.

    All times are in UTC. Be sure to adjust for your process needs.

  5. Choose a start date in the future for your workflow. 
  6. In the Frequency list, choose Daily
  7. Save the trigger. 
Was this article helpful?
YesNo