-
Feedback Needed on Status Rollup Solution
Hi all, I have a bunch of underlying sheets that have the exact same setup due to a template and it has a status field with a drop-down of about half a dozen different options that go sequential order from not started to complete and verified as complete from leadership. We also have hierarchy so there is level 0, 1 and 2…
-
Save as New Issue
Hello, I'm encountering an issue when attempting to copy certain Smartsheet sheets. When I try to "Save As New," the process consistently times out, indicated by a spinning cogwheel. On occasion, I also receive an error message stating that Smartsheet is unavailable. This problem is not affecting all of my sheets, only a…
-
How to automate data involving dates and sum totals
I have been researching this topic for some time now and have been having trouble finding an answer - hoping the Smartsheet hivemind can help! OBJECTIVE: To obtain a sum total of data submitted via a Smartsheet form, based on submission date. CONTEXT: I work for a transportation company, and we use a Smartsheet form to…
-
Automation template not working
I am trying to use the automation template in a work plan sheet, where when I change the project status column to "completed" the "% completed" changes to 100% on the row. I have even tried to reverse it, and say when % completed = 100% change project status to Completed. This seems like a very simple ask, and is a baked…
-
Keeping Separators in Numbers When Joining / Concatenating
I have had quite a few use cases where I needed to use a formula to calculate an amount or amounts then join that amount into a text string, but when you do that, you lose your separators. If you want dollars, you also end up with no cents or single digit cents which can look a little wonky. The below formulas can…
-
Smart Sheet & Resource Management - Functionality
I'm wondering if a) Smartsheet is working on the issue and b) if anyone has a workaround. I'd like to see the status of a task, as it's marked is RM connected to a column in Smart Sheet
-
What’s Your Elevator Pitch for Smartsheet? 🚀
Hi Smartsheet Community! I’m curious—how do you sell the value of Smartsheet in 30 seconds or less? We all know Smartsheet can transform workflows, improve collaboration, and make life easier—but when you’re trying to gain buy-in from leadership or teammates, what’s your go-to elevator pitch? Here’s the challenge: Keep it…
-
Form Logic based on multiple column selections
I've had few interactions with Smartsheet users in the Unanswered Questions that have prompted a form upgrade idea that I believe would be useful for many. It would be nice to have the option for logic on a form to trigger a response based upon multiple column selections. I have had multiple questions asked on Unanswered…
-
Post Dashboard Demo Questions
I always get the same question after I do a dashboard demonstration. 😂 "How do I export this to Excel?" What are some questions you get after demonstrating a Smartsheet dashboard's capabilities?
-
Bulk deactivation of automations
It would be incredibly useful to enable owners or admins to bulk deactivate automations within sheets. I'm currently having to manually deactivate 144 automations one by one!, the ability to 'select all' would be very useful when doing updates to my sheets.