-
Request to Restrict Sheet View by Current User in Report
Hi, I'm looking for a way to restrict the view of a sheet so that each user only sees the rows relevant to them. I know this can be done using Dynamic View, but I want users to be able to update multiple rows directly in the sheet, without having to open each row individually in a form. Here's the situation: I have a sheet…
-
Change Dropdown Column Value for Multiple Rows at One Time
Simple question here: I want to change the Dropdown value of multiple rows at the same time. Select Rows, 3, 5, 6, and 8. Change these rows' Column B (dropdown) value to "Value X". Right now I can select multiple rows by clicking while holding shift. But then when I try to change the column value for them all, it just…
-
A Method to Increase the # of Trusted Domains Beyond the 20,000 row limit
There are MILLIONS of domains. We are attempting to streamline our trusted domain list across all our company applications and our exemption request process so approvers only have to approve domains once for all applications, domains are assess and approve consistently and build automations to add approved domains to the…
-
Function for "current user" to use in formula?
Good morning, Is there a function of some sort that I can use in formulas that evaluates to the "currently logged in user"? Use case: I have a Sheet that that has an Assigned To column and a Consult With column, both of which are multi-select Person columns. The Sheet also has a Status column. I'd like to create a Filter…
-
[Control Center] How to rename Intake Sheet? Admin workspace?
Hey there, we're trying to rename our Intake Sheet & wondering what the best way to do this is / anything to watch out for. We would also like to rename our Admin Workspace. Looking for advice before we go messing with anything. Let me know if you need any additional details & thank you in advance!! EDIT: So I went ahead &…
-
Export Column Properties
I would like to be able to export the column properties of a sheet. It would be incredibly beneficial to be able to export the extensive structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only…
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.
-
Export Column Properties
Is there a way to export the column properties of a sheet ? It would be incredibly beneficial to be able to export the structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only Add contacts…
-
Better Document Generation Attachment Options
It would be good if we had more control over how Document Generation Attachments are added to a row. We have a use case with two Document Generation workflows – one for updating a PDF during preliminary statuses (New, Revised, etc.), and the other upon reaching Approved status. They each create a PDF with the exact same…
-
Are New Folders No Longer Allowed In Sheets Directory
Not sure when this changed, but it was recent. I used to be able to create folders for organization within my Sheets directory. Now there is no option to do so. The menu options are gone. If I create a folder in a workspace, I cannot drag-and-drop it into my Sheets directory. Right-clicking "Sheets" in the Browse panel no…