-
Adding multiple lines to a metric?
Hi all is there a way to add multiple lines to a metric? As an example, I'd like to add a sum of the cost below the metric in the same bubble, I have both the sum of renewals & dollar amount in my pivot, just wondering if I can link both to one widget rather than creating another.
-
How do I get more column options and labels in Office timeline
Using office timeline, why can't I select all of my columns? the template I want to use has all of these different column options and left column organizers (see photo), but when I import my data using the same template, this is what mine looks like
-
ODBC Connection fails from SSIS and Excel - SSO Token configuration
We use VPN, single sign on from Office to SmartSheet and I got my SmartSheet token generated. I have ODBC 64bit 1.4.34.0 connector installed and configured with my email and the token. I tried to connect from MS SQL SSIS 19.1 TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL…
-
Smartsheet - Jira Connector Custom Fields
Hi Smartsheet Community, We are trying to integrate Jira with Smartsheet via Jira Connector and found that only system fields are available for selection and none of the custom fields show up in Smartsheet for bidirectional integration. Our bidirectional integration is successful for Jira System Fields but not unable to…
-
Different contact information depending on single or multiple contact columns in Power BI
Data exported from Smartsheet with individual contact columns is displayed in Power BI as email addresses. Multiple contact columns, on the other hand, are displayed in Power BI as user names. Is there a way or a setting to make this consistent? Imported into Power BI using the Smartsheet Connector: Thank you for your help!
-
Import Microsoft Excel vs Data Shuttle - Not Consistent
I'm running into an issue between how Import Microsoft Excel works vs Data Shuttle. I have a csv file from GA that looks like this Nth week Average engagement time per active user 0000 112.22953736654804 0001 70.001269035533 0002 64.25891677675033 It gets imported with the first column losing the leading zeros. Then there…
-
Integration of Smartsheet to TaxWise software
Hello, I have documents stored per row for each tax filer in the sheet. However, to enable seamless operation, the tax preparer would like the documents to be automatically transferred to the filer's account on the tax preparation software called TaxWise. Does anyone have any idea how this can achieved ? I’d really…
-
Project Name for Project Status Log and automations
I'm working on a global update where I want to add a column to reflect the project name so all the automations include the correct project reference. We use a template that is consistent for every (new) project created. My goal is to add this new column to the overall admin template so both existing and future projects…
-
Power Automate & Smartsheet
Hello everyone, I'm currently working on a project involving Power Automate to create folders in SharePoint whenever a row is updated in Smartsheet. I want to use the updated value in a particular cell as the new folder's name in SharePoint. I've been following these instructions, but I'm having trouble finding the "Get…
-
Is there any quick way to integrate ServiceNow ITSM with SmartSheet?
We have an in-take form created in ServiceNow for our users to submit their Application Change requests. Our project teams use SmartSheet for tracking and managing these requests within their projects. Currently, we have to manually take the requests data and enter them into a SmartSheet 'backlog'. We are wondering is a…