Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I need a zap created to look up a cell in Smartsheet, and look for the text “Prospect Edification”. If it exists, then delete it from that cell, but keep all other text in that cell.

Everything is straight forward and working except deleting ONLY “Prospect Edification”. Is there a way to delete only this text and keep the rest?

There is a couple filters too…. here is more or less what I want:

If ColumnA = “Yes” and Column B is not blank, look up Column C for “Prospect Edification” and if it exists, delete text “Prospect Edification”

Thanks so much!

Hi @Davyn 

Good question.

Might best to open a ticket with Zapier Support for guidance: https://zapier.com/app/get-help

In some other apps they indicate how to clear the contents of a cell with certain formatting.

Hey @Davyn happy to help out with this workflow! It sounds like you could achieve this by using the following steps (after a new row trigger or find row action for Smartsheet):

  • Filter Step
    • If ColumnA = “Yes”
    • Column B is not blank
    • Column C contains “Prospect Edification”
  • Formatter Text Utility > “Replace”
    • Leave the value you want to replace it with, empty. This will ensure “Prospect Edification” is deleted from the string of text.
  • Update Row
    • Dynamically select the row by using the row ID from your previous Smartsheet step
    • In the “Column C” field, select the output of the previous Formatter step

Give that a go and let me know how you make out!

Hi Jesse,

 

This is great thanks! I set it up and it’s giving me an error “

Failed to create a row_update in Smartsheet

The app returned "Value is not supported for this column type. Use objectValue instead.".

 

I am assuming this is because the column I am changing text in is a multi select dropdown… is that correct? 

 

Hi @Davyn 

Good question.

Might best to open a ticket with Zapier Support for guidance: https://zapier.com/app/get-help

In some other apps they indicate how to clear the contents of a cell with certain formatting.

 

Thanks Troy… I will go that route if I can’t resolve it here. Cheers

Hi @Davyn! I looked into this and you’re right that it’s the fact that you’d like to change the text in a multi-select dropdown that’s causing the error. The Smartsheet Zapier integration doesn’t currently support that type of field, I’m sorry about that! We do have a feature request open for this and I’ve added you as an interested user. This lets the Smartsheet team know how many folks would like to see this addition and also means that we’ll send you an email when we have an update.

K I am working on another solution with formulas in Smartsheet. 

Thanks!

Terms & Conditions