-
Importing Excel Document adding apostrophe to certain cells.
I imported a simple 4 column excel document with around 8,000 rows. The columns are Item, description, UOM and cost. I am using the item and description to write a VLOOKUP on a separate sheet. For some reason in the item column (Which are all item codes) if an individual cell has only numbers, it adds an apostrophe BEFORE…
-
Why when importing an Excel sheet, the top row does not display to select column headers?
When I try to import a specific Excel sheet, the top row does not appear for me to select it for column headers. The row is a text only row and under the character limit. I even created another row at the top of the sheet with short descriptions and I do not see that either.
-
Create a formula to calculate the price of comma delimited items in 1 column.
I have a vendor registration form that connects to Smartsheet from Google Forms using the Smartsheet Add on for Google Forms. When completing the registration form, the vendors can select up to 4 tables to rent and each table may have a different price. The form automatically created and populates my Smartsheet with the…
-
is "export gantt to image" completely broken?
The text looks terrible on the image when i select this option? I need it to be an image to insert into other documents.
-
Error exporting smartsheet to excel
I have been trying to export one of my Smartsheets into excel but am getting the error below. Can anyone assist with this? I was able to export other sheets similar in nature but not this one.
-
Smartsheet Forms - Email Submission Changes?
I have a form that captures order requests for equipment. I'd like for the submissions be emailed to me once a week. Is there an automation that can export the submissions and email them to me once a week?
-
Export List of Archived Users
As confirmed by Smartsheet Support, there isn't a direct way to export a list of all archived users; the only way to get this information is either by manually scrolling through the Archived section, or by deduction (names which do not appear in the exported people list). The existing 'People List' only includes 2 user…
-
Alteryx to Smartsheet
Is anyone currently dumping data from alteryx into smartsheets? I would really like to be able to do it. Currently I am outputing to G.S. and then pulling the data into smartsheets via Data Shuttle. It works, but I'd love to cut out the middle man.
-
I am unable to import links in specific cells while uploading data in smartsheets from excel.
I cannot use row level attachment feature as I have links in multiple column
-
using Smartsheet sheet/dynamic view to pre-populate Smartsheet form
Is there a way to take data value from the sheet/dynamic view and auto create a form from the data? i'm working on a 3rd party invoicing portal and i would like to auto fill the form base on the row that they have access to from dynamic view.