-
Import feature generates ~0 duration tasks
Does anyone else get errors, when importing an MPP file into Smartsheet? The most common error I find is that some durations are changed from valid values to " ~0 ". Has anyone else seen this? It happens EVERY time to a handful of tasks.
-
Use more row content as the default text of the subject field when sending a quick update.
We would have a huge increase in productivity if we could use more than just the primary column row content as the default text of the subject field when sending a quick update.
-
Trouble importing large excel file
I am trying to import a large file. It is under the 10MB limit, however it has 44k rows, and the standard import excel function only allows for 5k rows. Copying is limited to 500 lines. Is there any way to import such a large file, or can new imports be appended to existing smartsheets? Thanks, Adrienn
-
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…
