-
How to create a new row by pasting in data from Excel WITHOUT access to the source sheet?
Hi! I am working with a source sheet that has highly sensitive information, so the collaborators can't have direct access. Because of that, I have created a report where they can update only the rows they are tagged in whenever they need to. However, from time to time they will need to add new rows to the sheet using over…
-
URL Query String for a Multi Select Drop Down Field
Hi, I've read posts with similar questions. What I can gather is I have to parse out each of the drop down options into my query string but the posts I've read all have the solution incorporated after the URL? the adding & and list the field again with the second value and so on. My formula is all split up into individual…
-
Dynamic Data Validation with Columns from another Grid
Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that serves as tracking tasks related to the projects in the master sheet. When People…
-
Is there a way to impersonate Organization users views?
Often I want to see what my users see in order to help or prevent an issue. Being the system admin I am often shocked how my clean structure is displayed for those who may only have access to a single sheet in a workspace, and not the entire workspace. Is there a way I can impersonate another users? This can also help me…
-
Why does my Automation not show checkboxes as cells allowed to be changed?
Hello, Trying to set up an automation for PTO requests where once they have final approval it will check a checkbox column. This allows it to be automatically put into our employee scheduler. When I go to the automation and do the change cells one, I only have option for my primary column, and some dropdown columns. In the…
-
Extra, unwanted blank lines on a sheet
We keep getting a bunch of blank lines being inserted into our sheets causing filters to total up the incorrect number of lines with some data. It's really annoying. Can anyone help with this>
-
Read cell with comma as a number/value
Dear all, I have a column with numbers that can contain a comma. I need to do a sumif on this column, but Smartsheet reads this column as text, and therefore my formular does not work. I have tried different ways to convert the column to a number in another column, but I have not managed to find a function that works. I…
-
Best practices for multiple companies on one plan?
Hi everyone! We're using Smartsheet for PPM in my company and it works excellent. Recently, we're been getting more in contact with our subsidiary company, which are looking to do several projects in the coming year, but currently has no project management tool. We're talking about setting up Smartsheet in their branch,…
-
Suggestions for multiple file uploads?
I'm looking for suggestions on the best way to create an intake form that would allow external users the ability to upload documents in our system. The idea is that internally we would be alerted when documents are uploaded, review and approve them. External users may need to upload 15 documents. Any suggestions?
-
Smartsheet skipping rows when data entered into web entry form
Hi there, I have set up a web entry form on Smartsheet but am currently experiencing issues when someone submits a data entry to the form; the data entry skips first 5 blank rows of the smartsheet and is populated in middle row of the sheet. This happens even though the first few rows of the sheet are blank and have no…
