Is it possible to use the Field Logic in a Dynamic View to hide a row from the view display once certain conditions are met.
Example: Once the job status changes to complete, the row hides from the view.
Yes! You can use the Restrict View by Sheet Filter option from the very first page when editing your View, at the bottom of the General tab.
You would need to first set up the filter in the source sheet to show everything except when the Job Status is "Complete". Then once the filter is in your sheet, you can use this as a filter on your View.
Let me know if you have any questions!
thanks @Genevieve P ... Question; if l setup a filter in the source sheet to show everything but the complete status, this status will not show in the sheet, correct??
I just tested it and unless the settings are selected to Restrict View by Sheet Filter, the Dynamic View still shows the sheet as unfiltered.
Hi @Silvia Rangel
Sounds like you sorted it out! Glad you got it working 🙂
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,…
When I use Data Shuttle to import data to a sheet, it keeps adding a ' in front of the numbers which turns them into text and not numbers. For example, $23.50 turns into '23.50 when imported through Data Shuttle. The original excel file itself is formatted correctly. Anyone know how to fix this?
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…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.