-
SmartSheet API - Node.js SDK addRowUrlAttachment
What is the request body syntax when using the addRowUrlAttachment method in the Node SDK? The API documentation only shows an example using the addRowFileAttachment method.
-
API for linking MS Excel to SMARTSHEET
Greetings I am handling a number of projects and making Gantt charts to track their progress. The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem. I…
-
Manage multiple values in a cell from a dropdown list
Good morning, I am facing an issue on my smartsheet, i have a column (dropdown list type) that allowed multiple values per cells and i am trying to manage these different values in order to concatenate them the way i want in another cell. Does anybody knows the way to pick a single value from all of them or even the way…
-
How to export data to shared drive without Data Shuttle?
Looking for a way to schedule an excel file export that goes into a shared folder to automatically connect to powerBI. A workflow from Smartsheet to a shared drive would be ideal and allow our dashboard to be automated. Since we don't have data shuttle, it seems like the Live Data Connector could solve this issue but…
-
Index/Collect with Specific Criteria
I am trying to automatically populate the Parent "Content Development Status" column based on the most recent "Child" in the "Tasks" column, but there are certain Children rows in the Task column that I want to ignore. For example, if there is a webinar delivered, I do not want this to populate in the Content Development…
-
Know any knowledgeable resources interested in becoming a Smartsheet Innovation Specialist...
Alight Solutions is seeking a Smartsheet Innovation Specialist As part of our Professional Services - Global Project Operations team supporting deployment of HR and Finance Systems to large and medium size organizations, the Smartsheet Developer’s primary responsibility is to develop solutions using core and premium…
-
Automate printing labels
Is there a way to automate sending smartsheet data to another app or program to print custom Labels? Either with a button or maybe a checkbox in a "ready to print" field. Ideally this would be per row once info has been entered.
-
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
-
Project Progress/Reporting
I am creating an simple method to help us determine project progress to report back to our customers. The idea is to group tasks into phases and then classify each project as being in a specific phase depending on which tasks have been complete. Once all tasks in a phase have been completed, the sheet will report back that…
-
Retrieving Strikethrough Formatting with Python SDK
Hi all, I'm using the Smartsheet Python SDK to fetch data from my sheets. While the data retrieval works well, I'm encountering a limitation where cell formatting, specifically strikethrough, isn't captured. Currently, the retrieved data appears without the strikethrough even though it's displayed that way in the sheet. Is…