-
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…
-
Javascript fetch vs. Smartsheet
I am trying to query a smartsheet using very vanilla Javascript, see below. I verify that cURL will work using my API key, but the code below generates 403. I cannot use "require('smartsheet');" as the website platform does not permit. How can I get my Javascript snippet to behave as well as cURL? const apiUrl =…
-
Cross Sheet Reference stopped working
We currently have a Pharmacy Site API reference sheet that is updated daily at 2am PT. Since its a complete rewrite, the sheet is deleted then generated every morning with the new updated site information. This master sheet is indexed across several hundred Smartsheet solutions within our company. I have a specific sheet…
-
Automatic Time Tracker in Smartsheet?
Is there a way to automatically track time in smartsheet. For this example each row on a sheet is a job. I'd like to have a checkbox to have the job start, and a checkbox when the job is complete. To complicate matters, I'd also like the ability for the user to pause the job and restart the job. I am envisioning a "job…