-
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…
-
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…