Add Ons and Integrations

Archives for June 2021

Can I set a default view of sheet when I load it WorkApps?
I have a schedule that I've created in a sheet to have a calendar view as well. I've loaded the sheet into WorkApps, but I was hoping to set a default view of the sheet to the calendar view to make it available to others in our business. Is this possible?
Assigning Docusign roles to Smartsheet Columns
I'm stuck at Step 4. Does it not let me assign from this page? Do I have to add a formula in the Smartsheet to do this?
Data Shuttle (Delete rows that no longer match the filter criteria)
RE: Data Shuttle (Delete rows that no longer match the filter criteria) Scope of what I'm trying to do. Add rows when added to source file. delete rows when deleted from source file. Do not update rows. I've noticed when running the workflow I get a select amount of rows deleted and added again. I have an ID column that is…
10000ft Reports in Smartsheet
Hi Everyone, Is there a way to embed 10000ft reports to Smartsheet? I tried using the url of the report and add it as a web content in the Smartsheet dashboard. But the dashboard viewer has to filter it to check the specific report.
Alert Someone Automation - Reference Contact In Summary Field
When configuring an Alert Someone workflow and selecting "send to contacts in a cell", is it possible to reference a contact in a Sheet Summary field for the sheet? The drop down selection only shows contacts columns within the body of the sheet.
Expressions in Data Shuttle
Can someone PLEASE tell me how to write an Expression in Data Shuttle to give me TODAY's date in a column? Or even a TEXT expression that reads "IMPORTED". I can't get ANY expression to work. Thanks!
Dynamic View details pane
When selecting to edit a row with cells that contain a 0 (zero) stored within a text/number field, the details pane does not display the 0 (zero). Has anyone else come across this issue?
Asset Tracker via app search function
I am trying to search for a text numerical field i.e. FC090909 The app will find the field if there is a space in the field between the text and numbers i.e. FC 090909 but will not find the whole string if searched together with no space? What am I doing wrong? Thank you
Share Data Shuttle Workflows?
When someone creates a workflow in Data Shuttle to import data from a CSV file, how can we share this with other team members to support and adapt if required? Also if they are on leave, to enable other to run the workflow.
Moving up start date on calendar app
When I move the start date backwards on the calendar app, I have no issues. However, when I try to move up the start date past the end date, I receive a message saying, "End date must be greater than or equal start date". Shouldn't the end date just follow the start date if I have project settings enabled? I have the sheet…

Trending in Using Smartsheet

Why do I get a #Incorrect argument set error with the formula below/
=IF(Status@row = "Not Started", "Blue", IF(OR(AND(TODAY()>[End Date]@row, Status@row = "Not Started"), AND(TODAY()>[End Date]@row, Status@row = "In Progress")), "Red", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = "Not Started"), AND(TODAY(-5)>[End Date]@row, Status@row = "In Progress")), "Yellow", IF(Status@row =…
Admin Centre - multiple admins
Allow more than one user the ability to administer the admin centre. It is common for enterprise clients to have more than one administrator, therefore this creates bottlenecks in user management tasks, if that one user is busy or on annual leave.
Data Shuttle Error Code
Hi, I have a data shuttle configuration that had been working up until the past two runs when I get the same error. My spreadsheet hasn't changed and is not over capacity. There are slightly over 300,000 cells. I attached my workflow for reference. I also attached the exact file except I deleted all rows, but one. Also,…

Add Ons and Integrations

Discussion List