Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Different drop down lists in each row?
i'm 2 hours into this experiment so please pardon my ignorance. I'd like to create distinct dropdown lists for different rows in a worksheet. So the column header is "Color" and the first row is for "Paper" and I have 20 colors to choose from. The second row is for "Crayon" and I've got 100 completely different colors to…
Help with Auto Number/System - Created By field
I inserted a column where the type is Auto Number/System - Created By, but I am running into two problems. 1. The field auto-populates with email address. Is it possible to auto-populate with user name instead? 2. When adding the new row through a web form, the field populates with "web-form@smartsheet.com." Is there a way…
Smartsheet Integration with Basecamp 3
Does Smartsheets have the ability to integrate with Basecamp 3? Thank you, Katrinka Unold
Can I save over my existing sheet with an imported excel file?
Can I import an excel file and save over in order to capture updates without manually into the smartsheet? We distributing the exported excel version of our sheet to a customer who does not use smartsheet. They return an updated excel file, and we would like to then import their updated excel version to smartsheet and…
How do I automate an import data from CSV so that I get service tickets for my team based on priorit
Hi All: I would like integration of our Helpdesk system with a Smartsheet file (i.e. Team Task List by Priority template). The Helpdesk system is our database of service tickets that my team will need to work on and resolve. Having the capabilities of Smartsheet such as team sharing, update requests, and card view would…
Smartsheet User Meet (UK)
Would there be any intrest in a UK Smartsheet user group where we could meet up and discuss all things great and good regarding Smartsheet. It would be fantastic to meet other Smartsheet users and find out how they are using it and adding value at their organisations. We could also have some other guest speakers maybe…
Importing csv, google sheet, or excel data directly into an existing sheet.
Why can't you import excel, csv, or google sheet data directly into an existing sheet? Every time it just creates a new sheet, and then I must copy and paste the information into the sheet I wanted to place the data. In Access or other database apps, you can match fields and just import the fields you want directly into a…
Importing of Multiple tabs excel sheet
Hello, I am looking out for a way to import multiple tabbed excel sheet to my smartsheet workspace. I see it doesnt pick all tabs. Is there a different way of doing so? Or I have to import all as a different sheet? Kind Regards, Ashok
Random function
I'm looking for functionality that would enable a field to be completed with a random selection from a list. Is this something that exists within Smartsheet? I cannot seem to locate any formula code to accomplish this. In excel we would use a random integer nested in a VLOOKUP function that would generate a random number…
Sharing of reports without sharing the underlying data
Is it possible to share a report to a user, without them having access to the underlying sheet(s)? This means they can only see the entries that are relevant to them? I seem to think that the sheet(s) have to be shared as well as the report, but maybe i'm approaching it the wrong way