-
Include Parent Row text in JOIN formula
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. I need column "X" to be "BI, Engineering" =JOIN(DISTINCT(DESCENDANTS([Data Group]@row)), ", ")
-
Hiding Or Removing Duplicates In a Report
Hi all! I have a report on a sheet that has many duplicate values, and for the sake of nice presentation I would like them hidden. To further explain my situation, I have a sheet I am referencing that has tasks, days to complete, the week of completion of these tasks, and finally the avg days to complete a task per week.…
-
Convert drop down in text format to date format
I have seen various other questions in the community, but I can't quite get my equation there, I am trying to convert a drop down from a form to a date in the adjacent column. All dropdown items are formatted as follows: 7/07/20 Here is what I am trying: =DATE(VALUE("20" + RIGHT([Testing Date]@row, 6, 7)),…
-
Formula won't recognize cell data
Hi, I have several formulas in sheet summary that reference a single person in an assignment column in my sheet. The formulas are repeated multiple times and work just fine, however I seem to have issues with this single person. Any formula that includes this person, does not work. Any insight on how to fix this? I've…
-
I am trying to find the right formula referencing dates and an identifier column
I am working on a formula to check all boxes in the rows that match the identifier column if there is a projected date and it is greater than or equal to today. I collect the start and end date and if a class is delayed or ahead of schedule it collects the projected end date. What I want is if the class is still going on…
-
Formula, checking a Box with multiple criteria
Hello everyone, I have a question. I am trying to create a formula which is supposed to check a box if a specific word (lets say word1) is in column 1 and there also is a date in column 2 or if there is one of two words (lets say word2 and word3) in column 1 and a date in colum3. So far I have this: =IF(AND([column1@row =…
-
Populating the Parent Row from Another Sheet
I have a spreadsheet that contains all of the inventory information for a lot of products. These products are broken down into categories. For example, shoes (a parent row) would have the child rows of sneakers, heels, slippers. I am receiving orders from products onto another spreadsheet via a form. From the form, I am…
-
Formula to get group from belonged user
Since the groups are the only way to categorize users, we use groups as "departments". I'd like a formula to get the name of the group where each user belong to. thanks
-
Combining two formulas to filter data
I need to create a formula to count any lines that reference "GEMS Point", that will further filter only for any references within a given month. I have the following two formulas that are working perfectly: Formula for total by GEMS Point: =COUNTIFS({GEMS Point}, [Primary Column]@row) Formula for January programs…
-
#INCORRECT ARGUMENT SET on Index/Collect Formula
I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a…