-
Calendar app not showing line items when more than one value chosen in a multi-select filter
I can see line items properly in regular SS calendar view but in the calendar app it is not displaying items it should when I filter for line items that have more than one value selected in a multi-select column. When no filter is selected, the line items appear. The filter works when i chose ONE value but not when i chose…
-
Removing duplicates by moving to another sheet
Hi, I have sheets A and B. Sheet A is set up that with a row that marks all duplicates as 2. I want to set up a formula that says, "If a column Duplicates is marked 2 and the customer information contains the word outdated, only move the first occurrence to Sheet B. " Leaving one copy of the duplicated on the sheet. Thank…
-
Formula to copy parent data to child
Working with Tasks and SubTasks I dont always have SubTasks but when I do, I'd like to bring data from the parent to the child row. Can this be done with a formula?
-
Combining Columns on Sheet from Form
Good afternoon, I am working on an audit stock sheet, that allows a form staff can utilize for active counts and confirm physical location. With this I am trying to find the function to combine rows with the same Product Name, Product ID, but have the differentiator being the room it is stored in. See screen shot: With the…
-
Mapping out References
Is there a way to aggregate all of the managed references (both cell and sheet) without having to collect it manually? For example, I have one sheet that contains 14 cell references and 39 sheet references. Is there a way to export a map of those references so the client can see them rather than them hovering or going into…
-
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…
-
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…
-
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…
-
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…