Join

Hello, I have 2 sheets and I want to pull information from sheet to another sheet if certain criteria are met. The first sheet, "Slot List", is a list of clinical trials and the columns contain the study name and certain eligibility criteria patients need to meet to join the study. On the second sheet, "Trial Match", is a…

Hello, first time posting, long time smartsheet users. I am trying to include the parent row text in my formula but not sure how. My Formula will only pull the text of the CHILDREN but not the parent. I need column "X" to be "BI, Engineering" =JOIN(DISTINCT(DESCENDANTS([Data Group]@row)), ", ")

Hi Smartsheets community, I am trying to create a summary field in a sheet that joins all the text from one column that meets these criteria: has a created date less than 20 days old has a label of "decision" in another column OR a star for priority in another column. I have a sheet used to track RAID entries, and…

Hello! I have written a formula to drawn data from another sheet, however, when I add "IF(ISBLANK(" to it, it breaks. I've tried doing this two different ways: `=IF(JOIN(COLLECT({HF23 Vendors Acc/Dec}, {HF23 Vendors Email}, [Email 1]@row, {HF23 Vendors Acc/Dec}, "Yes"), ", ") = "", false, true)`…

An example would be to have a "Team Sheet" that has a column for "Team Dept." and another column for "Team members" that is a contact list type. In another sheet called the "Project Sheet," We'd have a column for the Project name, one for "Team Dept.," and then another for "Team Dept. Members." I'd like to use Team Dept to…

I have the columns "Auto number", "I am following" and "Followed by". I manually maintain the "I am following" column by entering 1 or more IDs of other rows in blank-separated form. Now I would like to fill the "Followed by" column automatically by collecting all IDs of rows in which the respective row ID is mentioned in…

Hi, I have a Join/Collect column formula that I'd like to add a timestamp to. Is this possible? If not, is there a workaround? Sheet1 contains a list of Accounts populated with answers from a questionnaire. An Account can have multi rows. Sheet2 consolidates these answers into a single row. The column formula in Column3 is…

Hello Smartsheet Community, Has anyone successfully used Join/Collect to combine data from multiple columns? I have a sheet with the time submission/shifts worked by employees and another sheet for combining the data. I need to collect all of the approved shifts for a specified pay period for each specified person, so each…

I would like to display the Assignee(Contact field) of Successors. I currently use a Successor formula to successfully reveal which task rows are dependant. How can I also reveal who the next assignee of that task should be?

Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if you are trying to collect the entire row, I need specific row. Originally, I did this just by using JOIN and then selecting each cell, separated…