-
How to calculate % Planned in Father Rows?
Hi Community I created a new column to calculate the planned percentage in my project; however, in the father rows is not calculating correctly, even if I tied the percentage between complete and Planned, the percentage is not the same. I am using the following formula =IFERROR(IF(Finalizar@row = Inicio@row , IF(TODAY() >=…
-
Folder-level permissions
When will Folder-level permissions be coming out without the use of Collections? This was something discussed at ENGAGE 2023 if I recall correctly.
-
Restrict Who Can Delete Sheets or create Verification Check before deletion
I recently had an unlicensed user with Admin permissions delete several sheets that I own. I was able to recover them since they fell into my deleted folder. Can this be restricted to only the owner can delete a sheet (I thought this is how it used to work?) Or can there be a notification set up to the sheet owner if…
-
Comments for Conditional Formatting
When creating conditional formatting, it would be helpful to have a Comments field where you could add context on what the formatting is indicating, and why it is doing it. This is helpful when you have multiple people that manage the conditional formatting. See the attached photo for a mock-up of this idea.
-
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…