-
Send csv via email to update a sheet
Is it possible to send an email (with a csv attached) to automatically add rows to my smartsheet? My internal system has the ability to send csv files via email with latest changes - I want to remove the manual copy-paste inbetween step. Cheers
-
Salesforce Connector currency conversion
I am trying to pull a report using the Salesforce Connector with currency converted to USD. I know the field names, but they don't seem to be available for the Opportunity object. I checked and I do have permission to view and edit the fields in Salesforce.
-
Auto Filling a cell from data in another samrtsheet
Good afternoon I am creating a bid invitation sheet and need to list GC bidders per each job (row). * How do I create an autofill for these cells based on a directory I have created? * and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is…
-
Printing and exporting to PDF
Is there a way to add more page size options in the print and export to pdf forms? Custom page size? Or is it limited to the list of available options? Thanks in advance
-
Unable to export selected columns to pdf
Has anyone noticed that the "options" button on the pdf export sheet is not available? this is the button which allows you to select which columns to export thanks Neil.
-
Living Graphing Solutions to Embed in Smartsheet Dasboard
Hello I am looking for advice on the best tool to extract data from Smartsheet to a third party graphing service and then embed the 3rd party graph in a smart sheets dashboard. The two options I can think of are the !. Live Data Connector to Excel or Tableau 2. Power BI desktop Is anyone familiar with these methods or…
-
Importing Task Hierarchy from CSV file
We are looking to establish a daily import of our project portfolio into SS via a CSV file. When I look at the task import schema, I cannot see a way for SS to identify the parent and child relationships between the tasks. This means we cannot import nested tasks and the task hierarchy. Do you know if there is a field and…
-
Is it possible to take text from Grid View and present it in a 2x3 format?
Hello, I just received a Smartsheet license today, so very new at this. I developed a form to gather information from users and automatically plug into a sheet. This will work nicely for capturing the data, but not so much for presenting the info in a meeting. Does anyone know if it's possible to take the text fields from…
-
Numbers importing as Scientific Notation
I am working with PO#'s in a smart sheet and joining this data with a SQL database to combine a few tables. I use a visualization program called DOMO that I use to import the smart sheet data and the SQL data and join within the program to make one dataset. The problem I am having is when I import the smartsheet the…
-
Email daily comments on (multiple) sheets
This seems pretty basic, so not sure if I'm missing something. But, certain project stakeholders like to receive daily status emails that show the project activity. When I say activity, I mean comments, not who changed which cell. Currently the only way I've been able to do this is the literally grab screenshots of the…
