-
How to automatically remove "unmatched" datamesh results from the Target sheet?
Hi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically removes/deletes unmatched data --- rows in the target sheet that no longer reconciles to the Source…
-
ColabSoftware.com
Anyone using https://www.colabsoftware.com/ along with Smartsheet? We likely will be using ColabSoftware side by side with Smartsheet and any tips and tricks would be appreciated.
-
Clickable URLs in MS Teams alerts
Hi there, We use the Smartsheet alerts in MS Teams to let the company know when the editorial team has posted new content. However, the URLs in the alerts are not clickable, even if they are on the source sheets. I understand this is expected behavior. It would be fantastic if we could have clickable alerts in the Teams…
-
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…
-
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…
-
Using a formula to count numbers of projects assigned to an employee and at what stage its at.
Hello! I've created a sheet to pull metrics from for some charts I need to make and I'm trying to create a formula that counts the number of projects that are assigned to each employee and its progress level. I more or less understand the first part of the formula counting the assigned projects, but I'm stuck on how to get…
-
Can a duration column with dependencies not pull data from a created date column?
I have a sheet with a created date that is generated by the system upon submission of the project. I wanted to create a column that tracks the duration of the project from submission to delivery with dependencies, but when I click the drop-down under project settings it doesn't have that created date listed. Is there a way…
-
Find middle number using LEFT and RIGHT Formulas
I have a column with dates that look like this 2022-10-18. I am trying to create a formula using LEFT and RIGHT to only give me the month (in this example = 10) Please help, thanks!
-
Adding Condition to IF Statement
Hello! I have a smartsheet setup that is collecting data for an asset library. Part of the data is to assign ID numbers when specific values are met. I have 3 columns, I have a stock ID column that is populated manually with tock IDs. Then I have an internal ID column that is auto-populated via smartsheet when the stock ID…
-
Actions Button for Slack Integration
I am recently working on a workflow while utilising the slack integrations, particularly with notifications. However, I have seen that there can be actions set as part of the slack notifications on the smartsheet site (more specifically action requests (decline or approve)), but there is no indication this process can be…
