-
How do I list all predecessors (direct and indirect) for a given row?
Does SmartSheet have a way to list out all of the predecessor rows that feed into a given row? For Row 22 in the example below, I would like the formula to return the values 20, 19, 18, 17, & 16. Either that, or I would be looking for a list of all direct and indirect successors to a given row. Either would get me where I…
-
Highlight Changes Feature
When multiple collaborators are working in the same Smartsheet and the Highlight Changes feature is turned on and set to “I last viewed this sheet,” will the highlighted changes only appear for the first person who opens the sheet, or will each user see highlight changes based on the last time they viewed it? I am unable…
-
In Control Center: Link Assigned to, to Project Team on Intake
I have Control Center. We are set up to where the project team is not entered when a new project is created. The column is there, but the requestor doesn't necessarily know how the project team is. As we build out the project plan, I would like to have everyone that is "Assigned To" a task, auto-populate the Project Team…
-
Merged: Rebase line individual rows
This discussion has been merged.
-
Allow Adjusting Baseline for Individual Tasks (Row-Level Baseline Reset)
Idea / Feature Request I’d like the ability to adjust or reset the baseline for a single task (or selected tasks) instead of having the baseline feature work only at the entire-sheet level. Right now, “Set Baseline” and “Reset Baseline” apply to the whole sheet. On certain projects, especially in construction, only certain…
-
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?
-
Creating a formatted/merged email from a grid
I have a complicated workflow that I'd like to significantly reduce, in terms of time spent. Working from a standard grid, I need to format the email, pulling some summary information for a project and then adding specifics for each individual tied to each project. A few points: the summary information is currently in a…
-
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…