I have contacts in a Collect/ Join in an [Assignee All Row] Field At its core: JOIN(COLLECT([RowRange1]@row:[RowRange2]@row, NOT(ISBLANK(@cell))), ", ") As far as I can tell ", " Comma-space is the de…
Hello, I can't seem to get this right and after too many hours on this, I am escalating it to the formula masters of this great community once again. I am attempting to create a cell that will collect…
Hi There I have a sheet which is populated by a form (Booking Form) where the user selects a date, and enters her/his details and the number of people, As these people select dates randomly, the Smart…
All, First time posting here. I have two separate smartsheets (Smartsheet A and B). SmartSheet A contains our inventory. Smartsheet B consists of our Customer's Data such as which state they are in an…
Here is my JOIN function used on Name, Start Time and Finish Time columns that works fine. However, I want to use it with IF empty show nothing (currently it shows the delimiters). =JOIN(Performer1 + …
I am trying to concatenate text from 10 cells that are not next to each other into 1 while excluding text that is equal to "Not Required". This is the formula I am using to concatenate the text. I hav…
I'm currently using this formula: JOIN(DISTINCT(COLLECT({Training}, {Identifier}, [Loc - Employee]@row)), CHAR(10)) in order to pull completed training records for a list of employees. The idea is tha…
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 st…
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.…
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 "d…