-
JOIN + ACCOUNTING
Hello, SmartFam! I'm trying to join text with accounting numbers. but the join will not keep the financial formatting (removing the $ and correct , placements) Can you please help me get this right? VENDOR AMOUNT JOIN RESULT DESIRED RESULT AMAZON $435,678.90 AMAZON - 435678.90 AMAZON - $435,678.90
-
How to collect multiple Successor values?
Here's a link to my initial post which helped get me this far. RECAP: I use a combination of a Successor formula & Join/Collect in an attempt to report for my team the next tasks and assignee(s) in our waterfall workflow. I am able to successfully return the next assignee only when there is a single successor. I need to…
-
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…