-
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…
-
Using Check Box Column to Filter in a Row Report
I'm trying to us a checkbox column with a character "-" to filter items out of a report. I use the character with a white font to hide the checkbox when it's not needed in the row. When I select the criteria in the report filter (is not one of, is not equal to, does not contain, ect..) it does not filter the character…
