-
Automation Rule: Change Status to In Progress Based on % Complete Between 1% and 99%
I’m trying to set up an automation rule in Smartsheet where the “Status” column automatically changes to “In Progress” when the “% Complete” column is updated to a value between 1% and 99%. I noticed that there isn’t a “between” function available when setting conditions in the automation workflow. What is the correct way…
-
Distinguish Access Acceptors from Admins
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
-
Smartsheet Activity Tracker for Workspace
Random question for yall on a Wednesday.... Doing some workspace audit and reorganization and need to see if there is an easy way to see what sheets are and are not being used. Within an entire smartsheet workspace, are you able to easily see how many smartsheets that are actively using today / updating consistently? i'm…
-
Flag projects at risk
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?
-
How do I keep parent child row structure when moving items to and from other sheets?
I am working on setting up recurring tasks for my teams timeline sheets. I have 2 sheets set up to help the recurring task functionality. My question though is around if it is possible to set something up so that when an item is marked as complete the parent and all child rows are moved and they maintain that structure?…
-
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…
-
Rows could not be added to the destination sheet because it did not have enough cells remaining
I have a blank sheet that serves as a "backup" for our main sheet. We have an automation that copies the data from the source sheet to the to the backup sheet once a week. To work around the fact that smartsheet doesn't have a built in way to delete data, we also have a blank excel file that "uploads" to the backup sheet…
-
Master Project Plan
I have a massive project that spans across multiple regions. I want to segregate my plan into region sheets so when I update each individual plan the master plan will be updated. How can I do this?
-
Admin Center has been Buggy
Hello All, While Smartsheet continues to be a critical tool for our teams, the issues we’ve encountered in the Admin Center are beginning to impact efficiency and confidence. Some of the recurring areas we’ve raised include: User Stability: Users who we delete seem to randomly come back into our user lists. Has this…
-
Forms Set to Expire
It would be beneficial if we could set a expiration time on forms created for a workspace. We are using a form as an order form and sending the link out to capture order details, the customer only wants to offer this opportunity for 1 day. So we will have to delete the form but would be nice to just set a time period for…