-
Smartsheet ODBC connector not working - but only for Excel
I have ODBC connector installed. It was working fine with Excel until we switched to single sign on. Then it broke. I have followed instructions on using an API key for connectivity. These have not worked. I assumed this was an issue at the connector level. HOWEVER: I have just tried to connect using MS Access. The ODBC…
-
Control Center & Automated "Move to another Sheet" Issue
I'm working on my project plan sheet to use with Control Center. I support a multitude of services and when a Client Contact field is populated, that tells me that is a service the client purchased. My goal is to remove the services (parent & child rows) of the ones not purchased. I created a column Purchased Service to…
-
Data Shuttle Kicked off by Power Automate Flow
I am using a Power Automate Flow to create an .xlsx file and then run an Office Script on it. This is done within 1 flow in Power Automate. The file is saved to One Drive. Currently I have a Data Shuttle that I run manually to take the updated file and load to Smartsheet. Is there a way to use Power Automate to run the…
-
Is it possible to have different bill rates for one person in Resource Management
Hi, Is it possible to have different rates for the one resource in Resource Management. For example, on project A I might have a sell rate of $100 per hour, but on project B my sell rate is $110 and project C my sell rate is $95. Thank you, Adam
-
Can I allow used to add attachments/comments on dynamic views on a line to line basis??
I need to consolidate dynamic views. I currently have two views, one that allows users to add attachments and commends and the other does not allow attachments or comments. All other headers are exactly the same. I'd like to combine the two dynamic views. Is it possible to allow users to add attachments and comments on one…
-
Data Mesh "Update Immediately"
Hi there - I'm curious if any one can help explain how Data Mesh's Update Immediately works? Or maybe understand what's happening as it's no longer updating. In my source sheet: ID (made from auto # feature) then contact info. In my target sheet: ID & contact info, plus other data columns. I have my look-up value set to…
-
Control Center Global Update and adding a new external reference
Is it possible to update the calculation of a cell that includes a new external reference? I was thinking I could use search/replace but not sure since the help materials say that inbound cell links are not supported. My template set includes sheets, reports and dashboards. What if I just need to replace one of the sheets?…
-
Issue with Smartsheet Cell Limit - Data Shuttle
I'm trying to use Data Shuttle to import data into a Sheet upon attachment of an Excel workbook to the same sheet. When I attempt to run this Data Shuttle, I am getting an error that I have exceeded the 500,000 cell limit. The parameters of my source Excel sheet are as follows: Cells: 401,668 Columns: 40 Rows: 10,280 I…
-
BRIDGE - Using JSON as HTTP Call body
Hi all, I am trying to send a JSON payload using HTTP Call utility function, but on the target url I receive the payload as a string. I am actually using a Javascript script to build the payload and then using the reference as a body, but also trying using something like { "test": true } in the body will produce something…
-
What is best way to move SmartSheet column data to D365?
It does not appear that Data Shuttle can move data from SmartSheet to D365 tables. I imagine that we could build a custom flow using Power Automate assuming Power Automate has a connector to SmartSheet. But just wondering what other solutions or ideas are out there that someone has successfully implemented. I see there is…
