-
Tableau Smartsheet WDC -Unable To refresh smartsheet datasource in tableau server
I have a smartsheet sheet published as a datasource in tableau server. The initial connection to smartsheet from tableau desktop is made using WDC . the said WDC is enabled in the server with the refresh status also set as allowed. This is the result for "tsm tsm data-access web-data-connectors list" command Status:…
-
Need solution to "The columnid xxxxxxx is invalid" when using Zapier New Row Update
Hi Community, I'm looking for a solution to a problem that's occurring when using Zapier to update cells in one smartsheet from cells in another smartsheet. When using the Zapier New Row Update action on a Smartsheet, it's throwing an error: "The app returned "The columnId xxxxxxxx is invalid". This is occurring when…
-
What is the expiry time duration for refresh token?
I know that the expiry for access token is 7 days. Does refresh token expire and become invalid? If it expires, how does it help in refreshing the access token? Can someone explain how exactly the access token and the refresh tokens are updated after their expiry? Are there new values generated?
-
API Token - Can a Token be limited to a single sheet or workspace
I am looking to give an external developer the Smartsheet API so that I can get data to a specific sheet. I generated a new API ACCESS TOKEN and am concerned that this developer who I do not know (I am trying him out) will have access to all my sheets. Please tell me this is not true.
-
API sheet changes and Activity Log
Hi everyone, Hoping the great minds here can help solve a mystery. We recently implemented Control Center (first started using it on 5-Aug) and one of the manual tasks we've set up a workflow to notify our admins to complete each week is to update the Control Center generated link in our demand management sheet to show…
-
How to get attachments from each row from Smartsheet using Power automate using HTTP call
Hello- Could you please let me know how to get attachments from each row from Smartsheet using Power automate using HTTP call. Thank you
-
Can a one to many relationship be created in Smartsheets?
For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like and spreadsheet, but is there a way to link the value?
-
How to add new rows to category in smartsheet via form?
Hello, i need a form through which new products will be added. How to put them in the right category? For example, a checkbox where they offer to choose a category, and which one you choose, the line goes to that one.
-
Global Update Workspace Logo and Colors
Hoping there will be a future ability to update all Smartsheet workspace logos and colors from an administrative perspective across the board. At the very least creating some type of API call to revert to Account Color Settings and Logo so someone doesn't have to manually click on every workspace (I personally have 232…
-
Is there a package or repo to write whole Python pandas dataframes into Smartsheet?
I started writing some custom code using the Smartsheet python sdk to write pandas dataframes into smartsheet grids, but it gets complex pretty quickly with having to synchronize columns, efficiently running an upsert, and taking care of datatypes. So wanted to check if something like this exists already - seems like it…