-
When One Value Changes, I want 3 Cells to Change
When a new row is added, I want 3 columns to show 0% Complete. I have used 3 condition paths with the details of what I want changed, but as soon as it satisfies the first, it doesn't update the other 2. Is my only option to create 3 automations? There must be a way to bypass stopping once the first condition is met.
-
Index/Match, I *think*
Hi! I'm (I think) trying to make an index/match happen. I'd like Smartsheet to look for a matching contact in another row, and then copy three cell values from the lower row to the higher row automatically. Is there any way to do this? Alternatively, I could live with doing this for every column that needs it. So for…
-
this formula appears to work but it looks to be stopping after the first @cell
Assistance is required please - all projects are cancelled, so it should report 0, it reports 2, like they are not cancelled =IFERROR(IF(ISBLANK([Primary Column]@row), "", (COUNT(DISTINCT(COLLECT({2025 PMO Tracker V2 |Series}, {2025 PMO Tracker V2| PMO}, [Primary Column]@row, {2025 PMO Tracker V2| NPD-EXT}, "NPD-Category…
-
Using date columns in forms, ability to restrict to specific dates
When using a date column in forms, it would be great to have the ability to restrict it to a specified set of dates. And it would also be great to have the added option to automatically update the specified set of dates by, for example, removing dates once they are in the past. I have several different workarounds for the…
-
Return a date or month
Hello! Is it possible to write a formula to get the following result - Start Date Column: if it's a confirmed date, a date two weeks earlier in a photography due date column is calculated (this works by using this formula: (=[START DATE]@row - 14)) HOWEVER, if a start date is TBD and I put in the Start Date Column "March…
-
Radio buttons and checkboxes for dropdown lists
I would love the option to display a dropdown list column in a sheet as either radio buttons (for single-select) or checkboxes (for multi-select). I often use dropdown list columns with 2 or 3 options, and having those options displayed as radio buttons or checkboxes in the cell would be more convenient than having to…
-
Copy/move row workflow specify columns
For the copy/move row actions in an automated workflow, it would be nice to specify only specific columns to be copied/moved over to the destination sheet. For a lot of my sheet-to-sheet workflows, I have columns in my origin sheet which serve no purpose in the destination sheet. Even though I can hide those columns in the…
-
New Badge Ideas
Here are a few I think could be fun! “The Easter Egg Hunter” 🥚🔎 – Awarded to users who discover and share hidden or lesser-known Smartsheet features. “Smartsheet Mythbuster” 💡🛠️ – For those who clarify misconceptions, debunk myths, or provide expert-level troubleshooting. “The Lifesaver” 🆘🚑 – Given to users who provide a…
-
What view are you? Share your story and claim your badge
Hello Smartsheet Community, We love reading stories about the meaningful change you’re driving at work. Everyone has their own way of managing work, right? That's why we've ensured you always have a Smartsheet view that fits your needs. We want to hear how you are using Smartsheet and how it may change depending on the…
-
Get your Brandfolder Badge 😎
Hey Brandfolder Community, We love having you in this space — asking questions, learning, and connecting with other Brandfolder users. That’s why we decided to create something just for YOU. Presenting our brand new Brandfolder badge: Love it? Add it to your collection Engage in the Brandfolder topic, or tell us what you…
