-
Formula to Flag Duplicate Values
Hi - I have been trying to create a column formula that will flag duplicate values in my [SKU] column while leaving the first occurrence unflagged. Some of the values in the [SKU] column are either Blank or "TBD" so I would like to ignore those values. My ultimate goal is to be able to filter my report from this source…
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
-
Sum Multiple Drop Down Selections
I have a Smartsheet with a drop down cell that I can select each employee working on a task. Each employee has an efficiency rating from 1 to10 on another sheet. I want to be able to sum the ratings for each crew into a single cell. I have spent hours looking for a formula to do this with no success. I appreciate any…
-
Formula history is now viewable in Cell History in table view
February 09, 2026 Users can now view the history of any formulas entered into a cell using the Cell History feature in table view (an improvement over the current grid view experience). Learn More Environments availability: Commercial US, Commercial EU, Commercial AU Plan availability: Pro, Business, Enterprise, Advanced…
-
Currency converter
Hey all, Any tips and tricks to get around currency conversion within Smartsheet? I'd prefer to not have to manually update the conversion rate! Thanks, Matt
-
Access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
-
What Smartsheet templates are you using for clinical trial tracking?
Hey guys. Currently, I’m in clinical operations. I got a bunch of Phase II & III clinical trials in Smartsheet. We moved from Excel a few months back and still don't know the best way to set things up! The main difficulties I encounter are as follows: Tracking site activation in multiple states it's too dark Enrolling…
-
Counting occurrences of drop down menu selections
Hi all, I'm looking for a COUNT or COUNTIF formula to total drop-down menu selections within a given range of cells in a column range. The attached shows the DD menu with trusses selected. Our sheets are broken into calendar months, sometimes with over 100 entries for that month. Not every cell within that column has…
-
Connecting two Smartsheets (one a set list of assets, the other freeform)
I am trying to connect two Smartsheets. This is my current setup: The first Smartsheet (Smartsheet A) contains a list of shared assets, designated by an alphanumerical ID. When an issue is identified in one of these assets, it's set up so that when someone clicks the flag button, it notifies others. The second Smartsheet…
-
Marking Successors Status as "Ready" when the Predecessors Status is changed to "Complete"
I am working with a large sheet and developing an automation to update task statuses: when one task is marked as "Complete," the subsequent task is automatically set to "Ready." While my formulas are functioning correctly on a smaller scale, the size of my new sheet is leading to performance issues. Currently, my sheet is…