-
Prevent Overwriting of "Handler" Column
Hello, We have a smartsheet for our support team to claim requests submitted. As of now, when a form is submitted- every member of the support team receives an alert. From there, one of them must enter the sheet and elect themselves to handle the request (dropdown field with their names). We've run in to an issue where…
-
Placeholder for Start/End Dates
I've discovered that the % Complete column will only take into account rows with populated Task Start/End Dates - but this gives a distorted view of how much of the project is complete in the Parent Row. Is there a placeholder date or workaround I can use without making my own % Complete column using formulas?
-
Rows Not Appearing
I'm trying to troubleshoot a sheet I have. I have several entries that are not appearing on my sheet, and any new entries made are also not visible. I have a report generated off of the sheet and it reflects all of the entries. The approval, update, and assignment automation is also working just fine. They are given a row…
-
Metrics: Using the metrics template and metadata
I have the following setup: An Individual Project (Individual) A Dashboard Rolling Up Projects Assigned to an Individual (Program) A Dashboard Rolling Up All Projects (Portfolio) Each of the Individual, Program, and Portfolio has a metadata report and a metrics report Problem: I have to manually link the portfolio,…
-
Filter only children row when certain criteria is met.
Hello Community, What I am trying to do here is to display the milestones achieved by each client. The milestones are contained in children rows. The way to identify those milestones would be displaying the row with the highest date within its own family group and box check checked. Once I am able to filter the rows that…
-
Changing more than one sheet
Hi, I was wondering if there was a way to alter sheets based on a single template without having to go into each one individually? If I had a template that I used for different task lists and I wanted to add a column, automation, or even a choice in a dropdown, is there a way for me to do that simultaneously throughout all…
-
How to pull a number from previous row into secondary column matching using a row identifier (name)
Above is the sheet I am working with. I am keeping track of a weekly score for each student and want to try and pull previous weeks scores into the current week row so I can track scores over the past month for a specific student. Currently the formula I am using to pull the previous week score into the column 'LastWk' is…
-
Duplicate Values Returning in Search Results When There's Only 1 Unique Instance of the Value
I use SmartSheet to track projects (courses) that my team creates. Each unique course and lesson title is listed in the Project column. When I do a search for a project, the same project name displays twice as 2 rows with 2 different last modified dates. When I select each one of the projects in the search, they each go to…
-
Copying a Sheet & Using Formulas Changed the Form Attached to Original Sheet
Hi SmartSheet Community, I came across an issue with copying a sheet and the form that was attached to the original sheet was modified from using a formula in the copied sheet. Original Sheet Name: IHA Copied Sheet Name: Copy of IHA INDEX/MATCH Sheet Name: Job Model After I copied the IHA sheet (File --> Save as New), I…
-
Summary Formula
Hello, I am using Smartsheet for project planning. I would like to track adherence to plan, specifically counting the average of the Start to Plan and Finish to Plan and represent the number separately as a percentage so I can see what percentage we start and finish to plan when it happens. I have created an Ancestors…
