-
How can I collect and join IDs of other rows based on the own row ID?
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…
-
Add timestamp to Join/Collect Column Formula
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…
-
Combine shifts (dates worked/clock in/clock out/ activity type for specified pay period & person)
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…
-
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…
-
How to display the Assignee(Contact) of Successors?
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?
-
Combining selected cells into one cell ignoring blanks?
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…
-
Need help removing blanks from a join collect formula
Hi, I'm trying to use a join collect formula that referencing a column in a helper sheet. =JOIN(COLLECT({Column I Want Data}, {Reference Number}, [Reference Number]@row), ",") It's pulling everything from {Column I Want Data}, that matches the [Reference Number] with {Reference Number} on the helper sheet and any cell that…
-
% Complete Formatting in JOIN Formula
I am trying to Join various data points into one cell and when I join the % complete, it changes to decimal format. I've tried adding Value in from of the %complete, but get the same result. Can someone let me know if there is something I should add to my join formula to convert the decimal to percentage? Thank you Tiffany
-
JOINARRAY() function Idea
=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed. =JOINARRAY(", ", A:A, " ", B:B) results in: x 1, y 2, z 3 blank values are ignored, hence the over-ride for the end of the item delimiter
