-
Find Corresponding Value (in Pieces) in Other Sheet
I have two sheets: Sheet 1 that people use to submit requests for course redevelopments and Sheet 2 that has a record of all 1,000 courses (with a link to the "master" in our learning management system). We are in the process of standardizing the names of our "masters". Essentially, they contain three pieces of…
-
Creating a Master Sheet Composed of Dependent Dept Sheets // Sheet Linking // Sub-Sheets
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here is that while only I may have access to the the "Company All" the dept heads have access to their respective Department…
-
How can I insert multiple rows of external data without overwriting the rows below?
Oftentimes I'll copy rows from excel, email or my browser intending to insert those rows between used rows in my smartsheet. Although Smartsheet recognizes that I am pasting multiple rows, by default it will overwrite existing rows on the sheet rather than inserting new ones. This means that if I want to paste in between…
-
Sharing Sheets Automatically
Hi, Could we share sheets with new contacts automatically? I have a form and in this form I need to add a new contact, by adding his email. So a new contact is created in smartsheet automatically, but I need once this contact is added or when the form is submitted I need to share the sheet with him automatically, without…
-
Creating a New Sheet Referencing Cell Data from Other Sheets
In Sheet 1, I have several rows, each with information about a course being developed in a particular term. The sheet has a list of courses, within four parent rows, one for each quarter of the year (e.g., Parent Winter 2019, with several rows as children, one for each course to be developed in that term). There is a…
-
Date Formulas
Is there a way in data matrix to do a formula to count the the number of lines with a due date today to 30 days out? I am trying to see item that will hit in the future.
-
C# API Add Records from MS SQL Server
Hello, I'm trying to get records from a SQL table into Smartsheet using C# and ultimately SSIS (via script command). I'm stuck on how to add the rows into Smartsheet. 1. I want to add the rows dynamically without having to code the column id. I see that there is Bulk Operations but very little documentation for it. This…
-
Increase width of bottom scroll bar
We use Smartsheet on Chromebooks. Is there a way to change the bottom scroll bar setting to make it wider, as it's very difficult to find/access? Thanks.
-
How to lock column in report
How to lock column in report
-
Filter on Contact not working
Hi We've recently had reports that the filter on a Contact column is not longer working. If you select 'Is Equal To' and then select the contact from the dropdown, the smartsheet used to filter on that selection. Now it returns 0 rows. The workaround, which is far from ideal, is to use the 'Contains' option. We've also…