Hi all, I have a change log where the "Assigned To" column has multiple assignees - I have another column where I would like to return the department(s) of the assignees, which is pulled from another …
Hi, I have one sheet where there is a column with order numbers. There is also a shipping date column, which has a shipping date for each order number. The sheet itself is called Shipping. On another …
Dear All, would you please advise if this is possible? if yes, would that be a combination of JOIN/ COLLECT/ IF / AND? If no, is there a way around it? I need the dates in these 10 columns: to feed in…
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…
Our team is trying to build a tool to intake vendor reviews based on five averaged criteria to inform vendor selection on future projects. I've built the form, a review collection database, a review m…
I'm trying to have the Sheet Summary list the employee name from the Repeat Category Winner column with the highest Repeat Count per Category, and I have 3 categories that I will use this for (Timeshe…
Hello! I'm trying to create three (3) graphs with data we're keeping in a Sheet to go onto a Dashboard. There are 3 Teams that will each be one of the graphs, and then the data comes from a dropdown c…
Good Morning All, Currently have this column formula called "Count AD": =COUNTIF([Ad Name]$1:[Ad Name]@row, [Ad Name]@row) on lets say Sheet B I have the same formula on Sheet A: =COUNTIF([Creative Na…
