I have a smartsheet that is pulling data via Data Shuttle from a Google Sheet (the GS is populated with data from an Alteryx report every hour). Data Shuttle is set to update and add new data. Each line of data in the GS is assigned a unique number and that data is pulled into smartsheet based on the unique number.…
Hi, I have several calendar into a dashboard but when I ope my dashboard , calendars are mixed. Culdyou help me
Hello, I set up a new upload workflow to bring in data from a google sheet, and when the workflow ran it changed a handful of column types in the target sheet from text/number into drop down columns. This change broke all my formulas in a metrics sheet... After changing the column types back to text/number, all my formulas…
Hi Everyone, I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell. Does anyone know if this…
My manager has added a link to SmartSheet file in Zendesk side panel. However, when I click it, it asks for sign in. When I try to Sign-in, nothing happens. Any pointer to what could be the reason? Please note two members in our team can access it while other two can't (including me).
I am in the process of setting up a project blueprint. In my template folder I have a summary sheet of data that has ~10 cross sheet references to 2 other data sheets. Obviously to set those up, I added data to the sheet originally but then removed it so the sheet is clean when a project is created through the blueprint.…
Using Control Center I have a meta data sheet that contains profile data from an intake sheet via cell link that is crated through SCC. However, after updating information on the intake sheet the cell links on the meta data sheet are still showing the old information. Example: On 08/16 the Cell in the Intake Sheet was…
hey, which connector for jira and smartsheet do you recommend?
Hello Team, Anyone have a workaround on smartsheet salesforce integration, Need someone help on it. Thanks,
Deleted 5 rows from the Source sheet. Then deleted those same rows from the target sheet. The same 5 rows keep getting re-populated on the target sheet, but only the lookup values. I assume it is because I have "copy and add data" as the data mapping format in the Data Mesh settings, but that is the correct setting for my…
Hello, Some of our Smartsheet users are getting the error below when they tried to use the Smartsheet Merge extension with Google Docs. It appears to only affect newer users. We have other users who have been using it for a while and it still works fine. I tried to do it and got the same error. Any idea how to fix this? Is…
I am needing to import an excel sheet into Smartsheet with 10+ tabs at least 16383 columns. There are imbedded formulas referencing different sheets in the excel. Is there a way to go about this rather than importing one of the tabs at a time, and manually rewriting a lot of the formulas?
Help shape the future of Smartsheet. Share your ideas and feature requests.