Add Ons and Integrations

Archives for July 2021

Locking Rows in Dynamic View
Hello, I currently have a report in Dynamic View that is used by project leaders to update monthly financial data. I understand how to set specific fields to read-only but not entire rows. In the screenshot below, I would like to lock the "Target" ROW (highlights in blue) but would still like the project leaders to be able…
Data Shuttle - Skipping rows that need to be updated
I am using Data Shuttle to connect to an Excel file in OneDrive. I use a unique identifier column to look up that column in Excel and map it to the Sheet I want data updated to. I mapped the rest of the fields. It worked fine until few days ago. Now it is updating some rows, but not all. the Unique identifier has not…
Can I change the order of my secondary grouping in the Calendar App?
Hi, I'm having an issue getting the order of my groupings for my secondary column to appear on the Calendar App in the proper order. I am using a multi-select column from my main sheet. I understand I can not dissect the individual selections from the multi select column, but the order they are appearing is incorrect.…
Any recommendations for third party form builders with advanced date field functionality?
I'm looking for a third party form builder that integrates well with Smartsheet, and provides additional functionality around date fields. We need to be able to easily restrict dates based on pre-set deadlines (i.e. report requests cannot be made for any date less than 12 business days in the future). Ideally we'd like…
Control Center multiple projet creation
Hello everyone, I have a question about Control Center that is very important for us : Do you know if I can create projects within Control Center with multiple users connected simultaneously as primary lead account ? For exemple user 1 connect as primary lead generic account and create a project. While this is happening,…
Pivot does not update
the pivot table does not update if I change some data on the main table. Does anyone know how this can be solved? thank you,
Smartsheet ODBC Add-On
Hi - I hope everyone is doing well. Is there a Smartsheet add-ons that allows bi directional ODBC connectivity with other applications? We would like to refresh the sheets in Smartsheet via ODBC connections from various applications. Thanks in advance.
Do dashboards have to be shared for WorkApp
I am trying to make a simple hub work app. The app basically just displays one of my dashboards that contains useful links and videos. If I give someone a link to the work app, does the dashboard or the sheets it contains have to be shared with everyone for them to use the work app?
Calendar App
I'm trying to customize the colors for the Calendar App. I created a Calendar initially from a Sheet directly and from there I can see the option to customize each "Category" with a custom color, but when I try to do the same using a Report as the source, it doesn't give me the option for the Custom List Order even though…
Export Smartsheet data to PowerPoint Slide
Hi all, I am looking for a way to export my smartsheet data not to excel but to a powerpoint or other type of one pager solution that shows the data not in a table format but in some nice blocks etc. Is there any way to do that? Thanks, Judith

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