-
Counting rows after filters applied
I'm hoping this is a simple question with a simple answer but when I apply my fiilters to a SS, I need to count up how many rows are left, after I've filtered out the data I don't want. The rows are no longer sequential and are numbered to include the hidden rows and counting the rows manually would be a long painful…
-
Importing Excel sheet clarifications
I've been importing an Excel sheet for a while now. Formerly, I didn't care about the Primary column because I was just using the sheet as temporary means to get the data to the final sheet - where column types is more important. The first column contains a series of 1's and 0's. In the final sheet, that is a check-box…
-
Hierarchy from Excel
Hi all, I have an Excel sheet that I export from TFS and has a hierarchy defined. I would like to copy it into Smartsheet and maintain that hierarchy without having to manually recreate it. Can this be done? I am not opposed to using Excel to reformat appropriately. I am just trying to avoid recreating the hierarchy every…
-
Sage Integration
I would like to export data (or connect via ODBC) from Sage, i.e. sales order number, customer info, item and have this upload to an existing sheet. I have a web form for users to record data prior to completing the sales order. When they access the web form, I would like them to be able to select the sales order and then…
-
Feature Request: Preserve Formatting During an Import
When importing a file into SmartSheet, it would be extremely helpful to have a "Preserve Formatting" option. This will save the user much time in having to make the sheet look visually similar to its excel (etc) counterpart. This will also keep hidden rows/columns hidden, fonts and colors preserved.
-
Hierarchical List - display and behaviour query
I want to put this in Smartsheet and use the expand and collapse capability. However to get the indented list I need the name and number in the primary data column in SS. That is fine but when I export back to excel I will then not be able to know the 'parent' of an item or its level. The simplest thing would be to do as…
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Signatures on documents
Does Smartsheet have a Docusign options? Want to be able to email documents to get a signature.
-
Using Smartsheet data to populate project documents
I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering group. I presume there is no function in Smartsheets that facilitates the output of…
