How to filter text out in Data Shuttle

_Genevieve Evans

Hi everyone!

I am trying to filter out text in cells when I pull the information from Data Shuttle, but nothing else in the column gets updated. How should I do this correctly? Here's the Google sheet I'm pulling the info from:

I made the value under "Biomarker Assessments" = $2,492 so I can see if a change occurs in my target Smartsheet:

And I want Data Shuttle to not upload the words "Total Amount", so I have this:

But when I run the workflow, it does not update the target Smartsheet with anything, it keeps the original value under "Biomarker Assessments" at $2,490 instead of updating to $2,492.

I know I must be configuring this incorrectly, but the different ways I have tried to fix it have not been successful. I appreciate the help in advance!

Samuel Mueller

I think you want Biomarker assessments to "Not Equal" Total amount? I believe you also need unique identifiers for Data shuttle to work. Do you have those in a column somewhere?

_Genevieve Evans

Hi Samuel,

I tried doing the "Not Equal" before and got the same result. I just tried again and still no dice.

I do have unique identifiers: it's my Store column.

The workflow in Data Shuttle works great as far as updating the revenue each day, I'm just unable to remove this text.

Samuel Mueller

Do you have the workflow set up to replace all values or update values? If it's not replace all values then it wouldn't remove anything.

_Genevieve Evans

Gotcha, is there a way that it can just remove the text I put in? Is that possible at all with filters in Data Shuttle?

Samuel Mueller

So the filter you have if you make it "not equals to" it should ignore the text and not bring it in. you may have to delete it from your Smartsheet initially though. With the filter it shouldn't put it back when the data shuttle runs if you have the right filter..

Paul H

@Genevieve Evans

In when selecting your source have you tried using the first row option?

_Genevieve Evans

Hi @Paul H ,

I think the issue there is in my Google Sheet, the second row has the same header, so it makes it more difficult for mapping:

Unfortunately I'm not able to change that. This information is actually coming from Google's reporting tool Looker. It sends out a Google sheet on a frequency I set, and in order to pivot the categories out and see how much each category makes in revenue, this is how it's sent out from Looker into the Google sheet. So for Data Shuttle, I have to keep the first row option as 1 so I can properly map the headers to the Smartsheet columns.

Does that make sense?

_Genevieve Evans

@Samuel Mueller

I changed the filter to "not equals to" and it still brought in the text. I made sure to delete the text prior to running the workflow in Data Shuttle. I am definitely at a loss here.

Samuel Mueller

Take out the quotes and just use Total Amount

@Genevieve Evans

_Genevieve Evans

That did it. Thank you so, so, so much!

Samuel Mueller

No problem! It's always the little things lol