-
Auto group like cells
Is there a way to auto group cells that are the same, and add a count of them next to the parent cell? For example, I have a sheet that looks like the first screenshot (ex1), it's a list of SKUs within a program and a project. I want to group all SKUs within the same program/project and count the number of SKUs (see ex2).…
-
Alert when adding a new row
Hi, We have a sheet where we keep track of current statuses of our clients and this act as a mini project management tool for our clients. Each client is in a row and the stages are indented underneath. We would like to create an alert to notify specific persons everytime a new client is added, and this we have done it by…
-
Number and Fraction Format
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
-
Embedding Tableau Public link to a dashboard
Hi there, I'm currently operating on an Enterprise level version of Smartsheet and experiencing an error with my dashboard. Does anyone have experience embedding a Tableau Public link directly into a dashboard via widget? I see that this is an option and have tried both the link & embed codes, which both return the same…
-
I deleted my Predecessors column and now have no access to deleting any Predecessors relationships.
The docs say I can do this in the Gantt window, but I've found no specific instructions on how to do that, and haven't been able to intuit this process. Another solution would be to restore my Predecessors column. Inconveniently, copying and pasting columns between separate sheets "is not supported at this time." I imaging…
-
OR function to check a box
I am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem to work. There might be one small tweak I need to make, but I am still new to making formulas. Thanks for your help!…
-
Battle over Sorting and Filters
Greetings, We are starting to use Smartsheet heavily in a lot of our processes. We deal with contractors on a daily basis. We have several groups of contractors that view one master sheet and each of their own set of columns they review and work with. They may not directly interact with other parts of the master sheet, but…
-
Multiple section in a dropdown list?
Hi, Is there a way to select multiple items in a dropdown list? Here is the scenario i am trying to solve for. A product roadmap project may can be related to multiple products. I currently have a dropdown list column for products and each row is project. Currently i can only select one product per project. ideally i would…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Reaching for Specific Information Return
I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it. I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it then outputs that entire…