-
Join row data formula
I have two sheets for a traning evaluation form. They both have a common column, TrainingID. Based on that column I want to bring in data from one sheet to another. Example: For all rows that have BLS05 as a Training ID, I want the data columns from Facilitator Information to merge with the Evaluation sheet Facilitator…
-
JOIN function
I am trying to JOIN 2 cells (same sheet) and it is returning an error: =JOIN([# Dosed]2:[N]2, " / ")
-
#Nested Criteria when combining formulas together
I am trying to get this formula to work, but it kicks back the nested criteria. =JOIN(DISTINCT(COLLECT([Employee Number]:[Employee Number], [Created Date]:[Created Date], IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), [Employee Number]:[Employee Number], COUNTIF([Employee Number]:[Employee Number], @cell) >= 2)), ", ") I just…
-
Join Collect formula that excludes the current row from the results
I'm trying to create a formula that creates a list of duplicates in my sheets, I've gotten this formula to work but it's showing the original row within the list of duplicates. I tried adding an auto number column and including a condition that the list shouldn't include the current row. However, the addition of this to…
-
Run a formula on a destination sheet when rows are moved to it
I'm migrating a manual process we have into Smartsheet, and keep finding new hills to climb! : ) Essentially the process will result in document generation (PDF) after different team members submit info onto a sheet using Forms. First, I found a formula solution that worked for me to combine all sheet data (from columns)…
-
Join(Collect question
Hello, I am trying to join all notes in a cell from another sheet if the phone number on that row matches the phone number on my current sheet's row. I can do this in google sheets but struggling to translate to smartsheets. =JOIN(COLLECT({Notes}, {Phone #}, [Phone #]@row), ", ") This is returning 9 commas for each cell.…
-
Autopopulating a job number
I have set up a sheet that will house our jobs. It has been requested that each job have its own row, nestled under the customer's name. Our job numbers are derived by using the customer number, year, and job number for the year. For instance, the first job of 2024 for Customer A with a customer number of 1000 would have a…
-
Append cell value with previous value and new value from another cell
How do we append cell value with existing data.? for example. column source and target. target = target + source. so every value entered in source it should be appended to target with already existing value in target. any idea or formula , please help. thanks
-
How to Get "Responsible Email"
Hello @Everyone, I'm new here in the community, hoping to get support from someone who have work on the same use case I have below. Use Case: I have 2 tables, 1st table (Stakeholder Database) with column names Name and Email. 2nd table, (Sender Tool), with column names Responsible Name and Responsible Email. I want to seek…
-
How to return the contents of one cell that don't exist in another cell
I have an employee list where I'm tracking training status. I have a column with assigned training, and a column with completed training. I want to be able to display training that an employee has not completed. In the past I've used a JOIN(DISTINCT(COLLECT(CONTAINS formula to pull the training completed but would now like…
