-
Why is Dynamic View allowing me to build logic based off one set of dropdown values but not another?
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
-
Dynamic view without sharing underlying sheet
Having to grant access to the underlying sheet renders this useless for many applications. One application as an example - I was hoping to use it to give supervisors access to their employees' records so that we could keep all conversations and attachments in one location. But this would have given them access to all…
-
Is there a way to restrict the data entered into a row through Dynamic View?
Hello! I'm working on creating an environment within Dynamic View for employees to enter their annual bonus deductions. Is there a way to prevent employees from entering information into two columns if the total of those two columns exceed 85? I have a helper column that lights up when the total is over 85, but I'd like to…
-
Dynamic view for person & team
Hi I have several DV's set up for individuals to review a task list. These individuals are grouped into several teams. I have had a request to create a view that shows the team members tasks, as well as the tasks of other team members in the same team. Suggestions on the best way to achieve this?
-
Is it possible to hide rows based on value of a column in Dynamic View?
Hello, Using Dynamic View to allow users to see a report where we do not want them to have actual access to the sheet driving the report, so we have a report created that the dynamic view is on. Currently the report is pulling all data based on a couple filters. Ideally the group that owns the sheet and report can see…
-
@Mentions in Dynamic Views in WorkApps
I'm wondering if anyone has any good solutions for this case. We have developed a ticket system in sheets that filter to a report and then connected in a dynamic view. We add the dynamic view to a WorkApps that is partner facing. Partners are only shared to the WorkApps to see/work the tickets. They can edit certain cells,…
-
Help for Dynamic View, do "Shared Users" need a SmartSheet login
With a Dynamic View, do "Shared Users" need a Smartsheet login, or do they need to have previously logged in to Smartsheet before they can access a Dynamic View? I am not able to add several emails to the Shared User field under the Sharing tab. (but other emails can be entered). If this is a limitation, is there a way…
-
Row Delimiter in a formula?
Hi all, I have a sheet that contains hierarchy, I needed to make a dynamic view and maintain the hierarchy, which I partially achieved with formula columns. Long story short, I have a parent cell (program) and children cells (parts). In dynamic view I want to have 'program' in the main view, which I achieved and 'parts' in…
-
Dynamic view attachments and comments
I have a dynamic view that is shared to users outside our organization. I had the option to attached docs and also comment turned on. The issue I am running into is that all of the outside users can see the other users' comments and attachments. This is a problem because the attachments should only be viewed by our…
-
Can I change the size of the Details Panel in Dynamic View?
We have a large amount of content within cells that we are displaying in a Dynamic View. The current sizing of the Details Pane leads to a lot of scrolling and impacts readability. Is it possible to widen the Details Pane to allow for better viewability?
