I would like add a filter to import Data (Date) which is greater than a date.
Is it possible?
Hi @Eric Laitenberger
No, I don't believe you can use TODAY in the filter, it would need to be a UTC date. However, you could add a column in the source sheet with a formula to identify the criteria you need, then filter the DataShuttle workflow based off the output of this formula.
In regards to column names, you can have different column names in your Source data and in your Smartsheet Sheet, however you'll just need to make sure that you map the correct column to each other in the Mapping section of the workflow.
Yes, you can use the Filter tab in Data Shuttle to filter by dates, however the date will need to be entered in UTC format: (YYYY-MM-DD)
Try adjusting your formatting in Data Shuttle to be: 2021-01-01
Hi, yes perfect.
And is it possible to put a function? EG: "TODAY-1" instead of a date?
Sorry I have another question.
If I would like move line according criteria from shhet to another:
Must we have the same name of columns throught these sheets?
I have created a Data Shuttle upload, with no filters, to replace rows on my Smartsheet destination sheet. I discovered that all rows were not being added to the destination sheet. Debugging narrowed the problem down to the contents of one column. In Smartsheet, the column is formatted as Text/Number. In Excel for testing,…
We are considering upgrading to Advance, and I have questions about Bridge capabilities: Our project blueprint includes multiple reports that pull entries from master logs based on the job number. This means that our admins have to add the job number to every single new report filter when they set up a project. Can Bridge…
Hi, Can dynamic views be accessed on smartphones/mobile devices? I don't see this option on the app.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.