❓️Product questions
Sign in and ask it here! The community's got your back.

📈 Wondering if there’s a problem?
Check out the Status Page and subscribe for notifications.

💡 Share your knowledge!
Help others by answering questions.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Data Mesh Timing & Owner status in Activity Log
1st Question: Does the hourly option work based an hourly run? Or is it triggered an hour from the latest change? 2nd Question: If someone created the Data Mesh and then transfers ownership to you, does it show both of your names when the workflow is run for that app in the Activity Log?
Error Code: 1036
hi I was recreating an automation flow, when i run my flow. this was the error presented. How can i fix it?
How can I pull reports data from Resource Management connect to Power BI?
I'm not a developer and my knowledge of APIs are limited. I'm working on getting data from the resource management tool to power bi. I was able to pull all data, except for reports. I know I have to do a POST request, which I'm trying for the first time. I did run this query and I'm still getting errors. I'm getting this…
Bulk update of parent ID (Python API)
I'm building a project schedule that represents an overall manufacturing production plan. The the resulting Smartsheet has roughly 7,000 rows. I've found a way to use bulk API calls for all but setting the parent IDs, which is now taking upwards of 20 minutes. Here's the basic flow: -- Create production schedule in memory…
Smartsheet Automations and API/Webhook Calls
Hi there, We have a sheet then when an item in the sheet is marked as complete it is moved to an Archive sheet using Automation. The problem is there is so much data in a short period of time that we hit the sheet cell limit and have to export the data out into a CSV. I am wondering if there is a way using automation to…
I am identifying the duplicates in the sheet. What wrong with this query?
=RANKEQ([Request ID]@row, COLLECT([Request ID]:[Request ID], [Item Number (SUPC)]:[Item Number (SUPC)], [Item Number (SUPC)]@row, Duplicates:Duplicates, 1), 1)
Bridge: Passing parameters to child workflow
Hi, I have setup a solution to get data from Smartsheet Resource Management and send it to Smartsheet. I have 4 workflows setup in a parent child relationship to accomplish this. "SS - Update Budget Totals" > "RM - Get Budget Totals" > "SS - Add Totals Rows" > "SS - Add Rows" a) "SS - Update Budget Totals" calls "RM - Get…
How to get whencreated for a smartsheet user in the API
When we download the user report it includes both lastlogin and whencreated. In looking at the user api we see the option to add lastlogin which works great, but how can we get the whencreated for a user?
COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
Save as new//100 sheet limit - work around?
Hi - Does anyone have a workaround for this? I have a client where i have stripped the workspace back to around 150 sheets - they need to be able to replicate this workspace. I'm getting the same error message when trying to copy the workspace via the API - The end result means that due to this limitation, someone has to…

Trending in API & Developers

COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
When a new row is created in Smartsheet, Create SharePoint List Item
I'm trying to do my first Smartsheet Power Automate flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List. The part that I need help with is the mapping of the columns from the SharePoint Create…
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,

API & Developers

Categories

Popular Tags

API & Developers

Discussion List

Categories

Popular Tags