-
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…
-
Automatic sorting
i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in descending order?
-
Using Smartsheet Forms as multi lingual survey tool
Hi, I am using the forms function to collect data from people in many different countries. The information we are collecting is in binary, single select, and multi select formats. This information is being summarized in a separate sheet, where we are counting the instances of each response from the binary, single, and…
-
Can I populate multiple lines in a report from one form
I am trying to automate our joint health and safety checklist. I have created my data sheet with 88 columns and created my form. Each question has a drop down with yes, no or N/A. When no is selected a comment box comes up to insert the issue. What I want to do in my report is create one row for each issue that arises…
-
I need a report that only shows particular sections of the project, Is there a way to do this?
I have done a work around by exporting to excel and removing sections not required but I would like to have a report created based on a range of rows and put in a dashboard. Thanks
