-
Smartsheet alerts in MS teams - clickable URLs?
Hi there, One of our Smartsheet use cases is tracking content on a specific topic area (ESG). I added an automation that sends an alert to a dedicated MS Teams channel whenever a new content item publishes. However, the URL comes through as plain text and is not clickable. The URL is clickable in the sheet and I'm using…
-
SCC: Do all my intake sheet columns have to contribute to Profile Data?
Hello everyone, My team currently uses a form that populates an intake sheet. The form consists of key project data, as well as just some check-list items to make sure they did their due diligence before turning over the project. The form is around 40-50 fields long, and only around 10 of those columns I would consider…
-
Copy Row Automation & Parent/Child relationships.
OK, looking for some inventive ideas here. I have a budget sheet and a schedule sheet with a copy row automation, obviously this just copies to the bottom of the sheet, then I need to move each row manually to the right category, a.k.a below the correct parent row, in the schedule. Does anyone have any inventive ideas,…
-
DataTable best practices/searching capabilities?
Hi - We're working with large data sets that have to be hosted in Data Table, like vendor databases. In order to actually use the datatable in many functions I need to be able to allow for searching the database. Has anyone used datatable in this way? I.e. search for a vendor name and it comes back with vendor names that…
-
Loading SQL Data into Smartsheet
Hello, Is it possible to set up a connection between Smartsheet and SQL Server with automatic updates? For example, if I have a SQL query that updates daily, I want to be able to have a Smartsheet table with the same data that also updates daily alongside the SQL component. Is it possible to accomplish this without the use…
-
Bring data into Smartsheet with API or ODBC from Excel
Hi, Does anyone know how to configure Excel or Smartsheet so that a sheet can read data from Excel? I have it working so that Smartsheet is a source and use excel to pick up a sheet's data but not the other way. All the literature and videos say it can be done but I cannot find out how!
-
Dashboard Question
I'm working on a project where I'm tracking the completion of IT equipment refresh across 170 sites. Long story short my leadership wants to see a dashboard that looks similar to the very poorly sketched image below. Basically, they want to see out of 170 sites, what percentage of sites have completed: Task 1 Task 2 Task 3…
-
Outlook Add-In
The Outlook add-in is not installing for me weather I try to install it locally or on the web version of outlook. Its not my version or a permission issue as I have tried the install via local admin account which has full access to my system. Is there a downloadable version of the add-on that anyone has found?
-
Dynamic View Options for Sheet
Hello, I'm working on a quarterly goal review process. I need to keep all employees in the department on one main sheet with each employees' manager noted in a contact column. Then I've created a dynamic view based on current user (for the manager contact column) so each manager can view and evaluate the goals for each of…
-
Trying to locate sheet to see activity log on a published item
I have a published sheet link that works but I am unable to find the sheet used to create the published item. Is there anyway to locate the sheet from the created link? Joe Busch Urban Institute
