-
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…
-
Merged: Filters / folders in Dynamic View
This discussion has been merged.
-
Contact Collect/Join to Contacts will not filter (Current user)
I have contacts in a Collect/ Join in an [Assignee All Row] Field At its core: JOIN(COLLECT([RowRange1]@row:[RowRange2]@row, NOT(ISBLANK(@cell))), ", ") As far as I can tell ", " Comma-space is the delimiter for multiple e-mails in a multi-select column. FAILS: Filters on the sheets won't recognize (CURRENT USER) in the…