Using smartsheets as a CRM

Hi everyone,

In Smartsheets, I am trying to create a contact data base with a status trigger from a drop down menu... when "Lead Status" changes from "Lead" to "Opportunity" it triggers a bunch of actions I have set up through Zapier to set up the next steps, files, folders, etc. in Smartsheets and GSuite.

Does anyone know if there is a way in Smartsheets to trigger some next actions (either in smarthsheets or 3rd party app through Zapier) once the value of a single cell or column is changed? I only see this possible when a row is changed, but I do not want the actions to trigger if ANYTHING in the row is changed... just in a specific column

Thanks!

smartsheet lead status.png

Find more posts tagged with

Sales

API and Developers

Contacts

Integrations

Comments

Andrée Starå

Hi Davyn,

Yes, it is! You can set it up with Zapier and in Smartsheet with conditions. The best method depends on what you want to happen.

Can you describe your process in more detail?

Would that work?

Have a fantastic week!

Best,

Andrée Starå - Workflow Consultant @ Get Done Consulting

davyn88331

Hi Andree,

Thank you for taking the time to reply!

I want to trigger actions in smartsheets and other apps through changing the status of the lead in the status column.

When the status is changed to "Opportunity won" then:

1) A workspace is created for that contact

2) A template to do list is copied to the workspace

3) A Google Doc is copied from a template and attached to a row in the to do list (the to do list has a whole bunch of items that will be automated).

4) Some templated emails are sent out.

5) Folders in Google Drive are created for the contact

This is just an example of what I would like to do. My challenge is triggering these actions from changing the status of the row. I can trigger it from changing status in Insightly, but haven't been able to figure it out in smartsheets unless it triggers based on a change in the row which I don't want to do.

Cheers!

davyn88331

Hi Andree,

Ok I think I figured it out through adding a filter in Zapier. This now allows me to select the Status column and specify the trigger.

Andrée Starå

Excellent!

Happy to help!

To add to the condition/filter, you can also add Paths (Conditional Logic) in Zapier and multi-step Zaps so one Zap can trigger multiple things. It sounds like that is what you want to do.

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Were there recent changes to the totalPages parameter when querying the /sheets endpoint?
Up until last week, the totalPages and totalCount parameters functioned as expected when performing a simple GET call to /sheets. If there were 150 sheets, then it would show "totalPages": 2, "totalCount": 150. As of Friday of last week, it seems like it is showing "totalPages": 1, "totalCount": 100 any time there are more…