Hello! I was wondering if a functionality in Dynamic View exists that would pull data in from multiple sheets and put it into one view so a person wouldn't have to access different views to see tasks assigned to them. Thanks!
You can achieve this by using a report that includes your multiple sheets. In the filter settings, create a condition so that Contact Column should be "Current User". This is easiest if all your Contact Columns have the same column name, but it can be done even if that is not the case with a little more work.
I do this all the time, and it is one of my favorite features of SmartSheet. People only need to go to the Consolidated Report to see everything that is assigned to them, regardless of the sheet it is contained in.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello Smart-Heads! This one might sound trivial, but I am looking for an automation to copy limited amount of information from one row to a new row in the same sheet. The sheet contains initial generic information. Column E can be duplicated across the sheet with unique values from column F, assigned to column E, example:…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.