-
Need some formula assistance
Hello! I am usually pretty savvy at figuring out formulas, but I am truly stuck on solving this one. Does anyone know a way to solve for the below situation? I feel like it's doable and likely easier than the way I'm trying to approach it, but cannot get the right combination. Background: Our project plans/schedules have…
-
Smartsheet integration with Microsoft Tasks / Planner
I want to be able to update my actions in Microsoft Tasks / Planner Teams app, and have the updates reflect in Smartsheet, and vice versa. The available Power Automate triggers from Planner to Smartsheet and from Smartsheet to Planner do not seem to allow this to work properly. Likewise the actions don't seem to work…
-
Workflow, Reports, Dynamic View Connection Lists
How about creating an option to get a list of all connected items within a workspace? I have created a large ecosystem of sheets that are connected to each other, and some have flows, some have Dynamic views, some have cross-sheet references, some do not — it would be great to be able to select a workspace name, or even a…
-
What would be causing only some individual to not receive automation emails?
I have a simple automation set up to email a reminder to people listed in a contact list cell. When the automation runs, I get the email, others get the email, but one (possibly more) individual does not. This individual gets emails from other automations running in the company. The automation does show up in their…
-
COLLECT function and validate ISDATE
Hi, I am new to Smartsheet. I am trying ISDATE(COLLECT( function to pull an array and validate whether the values are dates. Is there a workaround? Similarly COLLECT(REPLACE( is there a workaround to modify the array?
-
Formula to check a checkbox, based on status of another sheet
I'm wondering if this is even possible. I have two sheets tracking monthly projects, one being a monthly content calendar and the other being our outsourced media. I have a formula created on our outsource media to update the parent status to "sent/complete "when all monthly tasks are completed (see first screenshot). My…
-
Tips & tricks for setting up workspaces
My team would like standardization on how we set up project workspace. In the root of a workspace, I expect we'd have a standard set of sheets for Schedule, RACI, RAID logs, Issues, etc. For folders within the workspace, we might have some kind of sysadmin folder for sheets where we could collect / aggregate metrics from…
-
Cell Reference, Contact List/Text
I have two columns in my sheet, both are Contact List columns and both reference columns in another sheet that are also both Contact List. Under Program Developer (below), you'll see the formula returns just the name, but under Program Manager, it returns the contact. I have essentially the same formula in both: Program…
-
Automation that sends alerts after 30 days of date column
Hey. Is there an easy automation that will send an e-mail to alert someone when a date is 30 days and 90 days old? I read there are some workarounds with helper columns and formulas but really really hoping there is a simple way to do this in 2026 and I'm just missing it…
-
Data Shuttle error message, locked resource
I keep getting this Smartsheet Data Shuttle message, "The workflow has been executed with an error. The resource you are attempting to access is locked" I am not in the sheet. Why? I am the owner of these worksheets. What do I need to do to resolve? Sometimes the error resolves itself though.