-
Is there a formula for one sheet to recognize data from other sheets?
Apologies in advance because I'm not entirely certain how to ask what I am trying to ask. We use Smartsheet as part of our transfer course evaluation workflow at a four-year institution. We are having to change some things in our workflow, and in setting up new sheets, I am struggling to find out if I can automate a…
-
Join text based on multiple conditions
Hello all, I need to Join the content of a Task column into one main cell in another column "Description". The conditions are: IF [Task] at row CONTAINS "Action Item" and Summary Field is unchecked than JOIN all the text separated by a comma (or even better assign a number to each of the tasks that contain "Action Item").…
-
Can you collate Ancestors based on another column condition?
Hi all, looking for some formula help. I would like to collate the names of my ancestors for a task in my "Stage" column, but only if the Hierarchy level of that parent or grandparent is >= 3. I have tried utilizing the Join(Ancestors(Task@row), " - ") and this returns all of the parent tasks. When I try to utilize an if…
-
JOIN(COLLECT()), Return Multiple Values/Contacts
Hi there! I'm trying to write a Join Collect Formula that will return the associated departments with a project based on the Owners noted on the project. The Departments column is a multi-select drop-down, and the Owners column is a Contact List contact. My reference sheet shows the Department and associated contact(s)…
-
Help with Join+Collect Formula
I need to reference another sheet to join and collect the skills of employees. The yellow is my desired outcome, and I'm using the following formula. Formula: =JOIN(COLLECT({Detailed Resource Data Master Range Skills}, {Detailed Resource Data Master Range Emp ID}, [Employee ID@row), ",") I'm not getting any errors, the…
-
Concatenating multiple fields from SourceSheet into one field in DestSheet
Hello all, I am new to Smartsheet and this community, so I apologize in advance if my question has been asked and answered numerous times already. I just couldn't find my answer. Here it is anyway: I am trying to concatenate all fields I find in "Note" on "SourceSheet" and place the conatenated string of text in…
-
Join/Collect (Distinct?) Help with Combining Separate Line Items Based on Unique Values
So I'm having an issue (lack of understanding) on how to use join/collect to turn a sheet like this: Into one that combines Qty/Supplies into one line item based on data from multiple other columns. End result like this: I would like to get it so that Supplies/Qty get merged when Department, ID Number, Drop Off Location,…
-
Cross reference match formula
I am looking to cross reference Sheet A to pull in Time slots from Sheet B. Criteria I need to have matching from Sheet A to pull from Sheet B to determine the slot number or multiple numbers. Start Time End Time There could be multiple Slot Numbers so it would need to be a multi option that I could use later to separate…
-
Joining text "if" a criteria is met in multiple rows / columns
Hi, I'm trying to do something a bit complicated and hoping for some assistance. I am trying to join text from specific columns IF another column has specific verbiage in it (Campaign 1). Below is an image of the rows and the column with that verbiage. Do you know what would be the appropriate formula for this? I want to…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…