-
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…
-
Project Planning: Percentage Complete from Dates
Hello I'm currently using Smartsheet for project planning. I want a forecasted percentage complete on progress to date from baseline start to baseline finish. Can anyone help please? Thanks in advance! :)
-
Improving wayfinding/navigation
Currently wayfinding in smartsheet is quite clunky, as via File > Properties is the only way find where we are located, or to jump to another place in the folder hierarchy. It would be great to have these breadcrumbs surfaced on every page in smartsheet.
-
Create a backlog item when status changes in a form?
I created an intake request form and it has a status field that on submission is set to Submitted as default. A email is triggered to the team that a new intake was submitted. The process then requires someone on the team to review it and set up a discovery session. Is it possible when the status changes from Submitted to…
