Cascade Strategy + Smartsheet

Update Cascade Strategy measures from newly updated Smartsheet rows

Whenever a selected row in Smartsheet is updated, this Zap will automatically update the selected measure's progress value in Cascade Strategy. Manage your updates seamlessly, without having to leave Smartsheet!

When this happens...
Updated Row
Triggers when a row is updated.
TriggerScheduled
automatically do this!
Update Measure Current Value
Updates a measure current value
ActionWrite

Try this template

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Choose a SheetRequired
  Select a Sheet to monitor for updated rows.
Trigger
Scheduled
Try It
- Choose a SheetRequired
  Select a Sheet to monitor for new rows.
Trigger
Scheduled
Try It
- Workspace NameRequired
  Enter workspace name.
Action
Write
- Choose a SheetRequired
  Select a sheet to add a row to.
- RowRequired
  Select row to add discussion.
- TitleRequired
  Enter discussion title.
- CommentRequired
  Enter discussion comments.
Action
Write
- Source FolderRequired
  Select source Folder.
- Destination FolderRequired
  Select destination folder.
- New Folder NameRequired
  New folder name.
Action
Write

- WorkspaceRequired
  Select workspace to be copy.
- New NameRequired
  New workspace name.
- What to Include?
  Choose elements to copy, Select "All" for copying all data.
- Skip Remap
  Choose references to NOT re-map for the newly created workspace.
Action
Write
- DestinationRequired
  Select your Workspace.
- Sheet to CopyRequired
  Select the sheet to copy.
- Copy Cells?Required
  Copy the cells from the source sheet?
- Copy Attachments?Required
  Copy the attachments from the source sheet?
- Copy Discussions?Required
  Copy the discussions from the source sheet?
- Sheet NameRequired
  The name of the new sheet.
Action
Write

- Choose a SheetRequired
- Row IDRequired
  Provide a row ID. When paired with Smartsheet's "Updated Row" trigger, this is the "Original ID" field.
Action
Write
- Choose a SheetRequired
  Select a sheet to send.
- Email Address(es)Required
  Email addresses of recipient(s). If more than one, must be a comma-separated list.
- FormatRequired
  Select file format for the attachment.
- Email Subject
  Leave blank for default.
- Message
  Personal message. Leave blank for default.
- CC Me?
- Paper Size
  Choose paper size.
Action
Write
- Choose a WorkspaceRequired
  Select which workspace you would like to share.
- Email Address(es) to Share ToRequired
  Email addresses of person(s) to share to. If more than one, must be a comma-separated list.
- Access LevelRequired
- Notify via Email?Required
- Email Subject
  Leave blank for default.
- Message
  Personal message. Leave blank for default.
- CC Me?
Action
Write
- WorkspaceRequired
- PlanRequired
- ActionRequired
- Action ValueRequired
Action
Write
- Workspace NameRequired
- Plan NameRequired
- Measure NameRequired
- dateRequired
- valueRequired
Action
Write

- Choose a SheetRequired
  Select a Sheet to monitor for new rows.
Trigger
Scheduled
Try It
- Choose a SheetRequired
  Select a Sheet to monitor for new rows.
Trigger
Scheduled
Try It
- SheetRequired
- RowRequired
- File AttachmentRequired
Action
Write
- Choose a SheetRequired
  Select a sheet to add a row to.
- Add Row to Top or Bottom
  Select whether to add the row to top or bottom of the sheet.
Action
Write
- Choose Source SheetRequired
  Select source sheet.
- Choose a Destination SheetRequired
  Select destination sheet.
- Choose RowRequired
  Select row to be copy.
Action
Write
- Choose Source SheetRequired
  Select source sheet.
- Choose a Destination SheetRequired
  Select destination sheet.
- Choose RowRequired
  Select row to be moved.
Action
Write
- DestinationRequired
  Select your personal Sheets folder or a Workspace.
- TemplateRequired
  Select a template to use.
- Copy Cells?Required
  Copy the cells from the template?
- Copy Attachments?Required
  Copy the attachments from the template?
- Copy Discussions?Required
  Copy the discussions from the template?
- Sheet NameRequired
  The name of the new sheet.
Action
Write
- Choose a SheetRequired
  Select a sheet to send.
- Email Address(es)Required
  Email addresses of recipient(s). If more than one, must be a comma-separated list.
- Choose RowRequired
  Select row to be sent.
- Email Subject
  Leave blank for default.
- Message
  Personal message. Leave blank for default.
- CC Me?
- Include Attachments ?
  Do you want to include attachments?
- Include Discussions ?
  Do you want to include discussions?
Action
Write
- Choose a SheetRequired
  Select which sheet you would like to share.
- Email Address(es) to Share ToRequired
  Email addresses of person(s) to share to. If more than one, must be a comma-separated list.
- Access LevelRequired
- Notify via Email?Required
- Email Subject
  Leave blank for default.
- Message
  Personal message. Leave blank for default.
- CC Me?
Action
Write
- Api Docs Info
  API docs for Smartsheet are located here https://smartsheet-platform.github.io/api-docs/
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- Workspace NameRequired
- Plan NameRequired
- Measure NameRequired
- Measure ValueRequired
Action
Write

About Cascade Strategy

Cascade helps organizations plan, execute, measure, and adapt their strategies in one place so they see business results faster.

Related categories

Business Intelligence

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Cascade Strategy + Smartsheet

Update Cascade Strategy measures from newly updated Smartsheet rows

Updated Row

Choose a SheetRequired

New Comment

Choose a SheetRequired

Create Workspace

Workspace NameRequired

Add Discussion to Row

Choose a SheetRequired

RowRequired

TitleRequired

CommentRequired

Copy Folder

Source FolderRequired

Destination FolderRequired

New Folder NameRequired

Copy Workspace

WorkspaceRequired

New NameRequired

What to Include?

Skip Remap

New Sheet From Existing Sheet

DestinationRequired

Sheet to CopyRequired

Copy Cells?Required

Copy Attachments?Required

Copy Discussions?Required

Sheet NameRequired

New Row Update

Choose a SheetRequired

Row IDRequired

Send Sheet

Choose a SheetRequired

Email Address(es)Required

FormatRequired

Email Subject

Message

CC Me?

Paper Size

Share Workspace

Choose a WorkspaceRequired

Email Address(es) to Share ToRequired

Access LevelRequired

Notify via Email?Required

Email Subject

Message

CC Me?

Update Action Current Progress

WorkspaceRequired

PlanRequired

ActionRequired

Action ValueRequired

Update Measure Historical Values

Workspace NameRequired

Plan NameRequired

Measure NameRequired

dateRequired

valueRequired

New Attachment

Choose a SheetRequired

New Row

Choose a SheetRequired

Add Attachment to Row

SheetRequired

RowRequired

File AttachmentRequired

Add Row to Sheet

Choose a SheetRequired

Add Row to Top or Bottom

Copy Row

Choose Source SheetRequired

Choose a Destination SheetRequired

Choose RowRequired

Move Row

Choose Source SheetRequired

Choose a Destination SheetRequired

Choose RowRequired

New Sheet From Template

DestinationRequired