-
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…
-
Can't access any sheets when they're shared with me
Hi, whenever my boss tries to add me as a viewer to sheets we use to keep track of clients I never receive an email telling me the sheet was shared to me, and the sheet never shows up in my "shared to me" tab. I can't figure out why this is happening. On her end, it says that she shared it with me and i'm listed as a…
-
Groups dropping from Alerts
Hi everyone, Has anyone had issues with Smartsheet groups dropping off alerts that have been setup? I've had this happen 3 times now and I have to keep adding them back. Thanks for any advice.