-
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…
-
Dynamic View Between 2 Departments with 1 source sheet
Hi! I was hoping someone might be able to assist me with a crazy idea and see if it's possible or if there would be a better option. Here it is: I'm wanting to create a single source sheet that would serve as the foundation of a data warehouse. It would have 2 dedicated admins who would act as bridges between both…