-
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…
-
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…
-
Smartsheet Consultant Required
Hi SS community, We are a small business based in Sydney, Australia. We are developing sheets to follow our multiple process flows and as they develop we realise we need advice on how to make them work for us and not against us! :D. We need that person now! Someone working on the Sydney timeline would be ideal. Thanks Dax…
-
Add_Row Data Format
Hello, I am having issues adding rows of data to my sheet through the smartsheet python sdk. I am successfully able to import files and create sheets but when I try using add row via the add_row method, but I see no update or data being added to my sheet. I am even getting SUCCESS status message back from the api request.…
-
In 10,000ft/ResourceManagement - How can I get full reports in an automated way? (api or otherwise)
Is there a way to get a full report in an automated fashion? By full report, I mean when you go to rm.smartsheet.com/report, and click "Run Report" or "Request Underlying Data" and you get back a full csv. (format doesn't matter, csv or json formats are both fine). I would like to download the report automatically on a…
-
I can't authenticate to Zapier, generate a working API token nor create a support ticket
I am a paying Business tier customer. Here are all the problems I encountered so far: When trying to authenticate to SmartSheet from Zapier. When I try, I get an error saying the user has not been found or I am trying in the wrong region error. I did some research, this might have to do with Zapier integrations apparently…