-
Live Data Connector (Data Extract from Excel Worksheet)
Who can answer technical questions about Live Data Connector to extract data from Excel? Trying to determine if one can: Include full path to Excel workbook in Smartsheet cell Include name of Worksheet in Smartsheet cell Point to designated Excel Worksheet in designated Workbook Transfer data based on Excel Worksheet named…
-
Email import via Zapier
Hi I am auto-forwarding certain emails from Outlook to a Smartsheet list via Zapier. Everything comes across fine but certain data fields seem limited in space. The body of the email doesn't fully transfer. It seems there is a character limit to either the Zapier forward or to Smartsheet. How can I get the complete email…
-
Is it possible to populate fields in Smartsheet from a 3rd Party application?
I've got a situation where we'd like to pull in some real-time data from our ERP system into a Smartsheet where we are doing some further tracking as things progress from month to month. From some light research, it seems as though an API could work for us, but I'm not too familiar with that and what our options might be…
-
Notification with Attachments
Hi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If so, do you know of any good apps/software to automate that process? I have looked into…
-
Slack Integration
I am trying to send alerts from Smartsheet to Slack but it is only displaying the primary column and the column that changed. On this page https://help.smartsheet.com/articles/2476711-smartsheet-slack-notification it says that you can display up to 4 columns in the notification. I can't seem to find where to specify which…
-
Synchronizing data from Microsoft excel into an existing worksheet in smartsheet
Hi everyone, i recently uploaded a file from excel and linked it to an existing worksheet in smart sheet. The file in excel is updated every week. Is there a way i can synchronize the file with smart sheet without having to upload the file again every week.
-
Form start timestamp
I've created a web form that will be heavily utilized. Managers are wanting to conduct a transactional analysis to see how long it takes the worker to complete. I'm looking for a way to capture the current time either when the form was accessed or find a shortcut to copy from the operating system and paste into the first…
-
Broken Pivot
When I go to refresh a pivot table, I get the following error: Error! The columnId 2691632771426180 is invalid. (1036) How do I figure out which column is the issue?
-
Formulas on target sheet not continuing when rows are added via datamesh
When a new row is added via Datamesh to my target sheet, columns in the target sheet that contain formulas do not trickle down. This is something that is a non-issue if data is added via a form so I'm having trouble understanding why it's not working in Datamesh.
-
Dropdown list - Update from the dev team ?
Hi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide simple solutions to my clients regarding their work (finance, managing team, project...). I…
