❓️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.

Looking for a Guru to Build a Smartsheet + Quickbooks Solution
Hi I have a small engineering company 15 people that has not been able to find a real good Portfolio management solution so am considering creating my own with Quickbooks + Smartsheet. I use Smartsheet for managing commissioning projects so would expand this to include all of the 125 projects we currently have on the…
Sharing a Folder
good Morning i have a workspace with 3 differen Folders. Is it possible to share each folder with differen people instead of settin all sharers at sheet level? Regards
Form Search and Auto-populate values
Hello, I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form and enter a key reference…
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…
Clone sheet and reports between accounts
Hi there, I'd like to take a sheet and some reports that operate on that sheet, and clone them over to a new account programatically. I'm able to share the items, copy them, and then un-share them programatically, but the reports then point to a non-existing sheet. Since I have quite a number of reports I'd ideally like to…
Smartsheet Dashboards vs Live Data Connector Integrations
Hi everyone, Has anyone used the live data connector to integrate with another platform such as Qlik or any other? I know that SM now has the dashboard view, but I do not think it is as powerful as other BI platforms. From what I see, the SM dashboard is a very high level overview and does not give the level of detail that…
Post api call to import into smartsheets. 502 error
Hi - I have an Excel sheet of data that I' m using to convert into json and then import into smartsheet. It is authenticated and runs fine till it has to actually import the data. It errors out at uploading the data with 502 connection was reset by a peer. I truly appreciate any/all help. Thanks Mythili
UI "Enhancements"
I know I'm not alone in my dislike for the new "hamburger menu" feature. It has resulted in quite a bit of retraining at our facility, across all 3 shifts, sucking time from my already packed day. The additional clicks necessary to access "active" sheets for the day is almost exhausting. While I certainly hope Smartsheet…
How do you resolve modules to use the smartsheet npm package on nodejs?
I am trying to use the Smartsheet API on nodejs (v8) on windows. When I add the smartsheet npm package, my solution no longer compiles. Easiest way to reproduce (though it reproduces without using create-react-app): > npx create-react-app solutionname > cd solutionname > npm start It works - your browser comes up with the…
API CSV import to active SmartSheet
Hello, I have written a program that utilizes the API from smartsheets; for simplicity, it just takes data from a source and imports it to SmartSheets. Problem is, it can only import it on a new sheet, not an active sheet. I understand that there is a tool that was recently developed: Data…

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