-
Connecting Smartsheet tasks to Microsoft Planner
I'm looking for help in the best way to connect a PMO Portfolio of Projects in Smartsheets to Microsoft Planner. I want to be able to enable all 'Assigned' rows in each and every project plan to automate into 1 Microsoft Planner carrying over the Project Name, Task Description and Due date. I also want to do the reverse.…
-
BRIDGE - (URL's & IMAGES)
I've created 2 Bridge workflows. Add the URL of an attachment to a row cell. This works perfectly, but the URL is only active for 2 minutes then it becomes inactive. ? Is there a way to make URL's permanent when using Bridge ? Insert an attached image to a row cell I have not been able to get this to work as I intend. ? Is…
-
Copy Row Automation to not include Attachments
Hi Is there a way to copy rows via Automations to EXCLUDE attachments? I know this is possible when manually copying to another sheet. Can you do this with Bridge or via the API? To exclude attachements when copying rows. Thanks you in advance. Regards, Pierre
-
Back to View - View not Displayed
I am setting up a Dynamic View to allow requestors monitor HR actions without making changes to the sheet. I am testing the View to ensure it works and am not able to see any lines that should be available to me to see. I have logged out and back into Smartsheet and I have restarted my computer. I only have the one…
-
How much does Data Shuttle cost?
Hi We're evaluating Smartsheet initially to create a simple CRM but it looks like there could be many other use cases for us. But all would involve data that is generated/updated by other systems - integration via CSV files is fine. So we would need Data Shuttle.I am finding it impossible to get price information for this…
-
Calendar View Integration with Outlook Calendar by filtration
Is there a way if I were in calendar view and have a filter setup (filtered by 1 specific name and task) I can have it integrated into Outlook based on that one filter instead of it all row submissions dumped into my outlook calendar at all?
-
The smartsheet power automate 'insert row' function treats numbers as text
I am pulling data from an erp system an pushing it into a smartsheet using PowerAutomate and the available PowerAutomate connector action 'Insert Row' -- the input data to that function is numeric but it is showing up in Smartsheet as text. is there anyway to get it to populate as numeric or do we have to do a formula on…
-
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…