-
smartsheet API key is not able to fetch data from the smartsheet having MFA.
I am not able to fetch data from the smartsheet using API key which is having MFA. I am getting an error - "This action is restricted by an MFA Policy. Please reach out to the workspace admin for any questions.". How I can resolve this issue?
-
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…
-
Task Details Alternative?
We're switching over from Asana where you can click into a task to see more details - this seems to be a basic function of every other PM tool platform. Smartsheet seems to be missing that. It looks like the only options are to add another column to serve as the home for task details - this feels clunky because if the…
-
Publish a calendar showing times through 3rd party integration
Looking for a way to publish calendars to outlook and have them display at the correct times, not as all day events. Based on community post review, I am assuming the following: It is not currently possible to store a time in a date column (although the created/modified columns have that ability) Published calendars show…
-
Bridge - JSON parsing - Remove HTML and match date
I'm looking for some help on how to extract particular data from a JSON response from an external API call made with Smartsheet Bridge. The API call is working fine, and I'm getting the JSON response. Part of the response is an indexed set of data within the response, that includes HTML formatting tags. I'd like to strip…
-
Automated integrations with Employment Hero, Xero, Artisan Plus.
I would like to be able to import data from several different platforms into Smartsheet and have Smartsheet update some data in a 3rd party platform. There's not much data to shift, so I can't afford an expensive solution, but if it's possible to automate that would be great. Specifically, I want to have our staff and…
-
How will the new email OTP login method impact Live Connector?
How will the new email OTP login method impact Live Connector’s 32-bit ODBC connection?
-
Automatically fill a sheet from a pdf or word doc
I have a word form that one of our teams needs to fill out. They then send me a pdf of the form and I need to enter the data from the form into a Smartsheet log. Is there a way to automatically scan the pdf and enter the data? I can also do it from the word form if needed. Creating the form in Smartsheet directly is not an…
-
Dropdown List Per Cell Using API?
I have been doing a ton of research on how to do a dropdown at the CELL level, instead of column level. All signs point to this being a lost cause, as the feature has been being requested for 5+ years now. However, one forum response indicated this is possible through API. Does anyone know if this is the case? If yes, how…
-
Sync Client between Smartsheet Project Sheet and Resource Management
Hello, Currently we are using Smartsheet and its integration with Resource Management. Projects are created in Smartsheet with a defined template and then they're imported on Resource Management. When the project is created in the first system, a lot of information are entered there, such as the Client. It would be very…