-
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…
-
Login to my app via smartsheet sso
I create a application with GUI to handle with data from smartsheet (crud). Then I make login module via OAuth2 flow to get the token to authentication and call some smartsheet API. But when I am done these procedures, I got a access token and refresh token which is not in jwt token. I use that token to call smartsheet API…
-
API License - Not tied to user
Hello, We are using API within a larger report and for auditing reasons we don't necessarily want the user's name that built the API to populate every time the job runs. Is there a way to create a license or account with just the API - not connected to an individual/employee? We understand that this may require an…
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
PICK CHART to determine Project viability
Hello, We are starting to use Pick charts to determine project feasibility and impact so that we only work on the most important things. It would be really great if a template set was set up with a project plan template like Template Set - Project Management Office where the template set would have a project submission…
-
Retrieve the form URL via an API call when the sheet is created
Hello Smartsheet Community, I hope you're all doing well! Im relatively new to smartsheets and I'm currently working on an automation process using the API's within Smartsheet where new sheets are created from a template. This template has an attached form that is crucial for our workflow. Currently, we can retrieve the…
