-
Checking for duplicates between two different sheets
We are setting up a raffle where we will send out a form for someone to completed to enter the raffle. Once submitted we will take the (Full Name) column and randomly select a winner. We do have a few things on this sheet, we check to make sure there are no duplicates on the sheet, and once a winner is selected and checked…
-
Distinct Numbers
Hello, I have a column "OPRO #" where it lists hundreds of OPRO # with many repeating number. I want to pull the unique numbers and list those in a separate column where each unique number has its own row. I am having issues finding a working formula. Thank you in advance for the help!
-
Help! Need to match a cell between two dates with complex conditions
Hi, I have a complex formula that i cant seem to figure out. I'll do my best to describe this below In Sheet 1 i have a unique identifier whose condition changes from blue to green after a certain date Unique identifier Condition StartDate EndDate 123456 Blue 1/5/2025 31/10/2025 123456 Green 1/11/2025 I want to ensure that…
-
Need Gov‑Safe Method for Detecting Resource Conflicts (Date Overlap + Name Match Failing)
I'm working in Smartsheet Gov, which has several limitations that don’t apply in commercial Smartsheet (ex: no Manage References, no HAS(), no FIND() in COLLECT, and very strict parser rules). I’m trying to build a “Calendar Conflict” flag in my Project Plan sheet that detects when: A task’s Start/End dates overlap with a…
-
Permanent Sort In Table View
Currently, sorting in Table View only impacts how data is displayed. It does not actually change the order of the underlying data. There are times where I rely on the data to be in a specific order (not just displayed). Lets say I have a project plan. There is a requirement that my child rows are numbered in chronological…
-
Automatically Setting a Future Date Based on Criteria
Is there a way in Smartsheet to automatically default a date column to 30 days in the future based on certain criteria? For example, if Column A has a value but Column B is left blank, can Column B be set to automatically populate with a date 30 days from today? I tried creating an automation where the trigger is when…
-
Set up Metrics
Hello, I am having a hard time figuring this out. I am new to smartsheet. I want to create this metrics table but I don't know how to create the reference formula!! Please help!
-
Unique() or Distinct() function for finding unique values
Hi, It would be very helpful if Smartsheet redesigns the DISTINCT function so it can be used not just as an argument, but also at the top level to pull all unique values from a column. For example, if a column titled Customers has many duplicate names, we should be able to use a formula like:…
-
Merged: Add a UNIQUE() Formula Function Similar to Excel
This discussion has been merged.
-
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…