-
Count Children If
Hi There I have a status column using the ryg balls Red, Yellow, Green and Blue. I currently have a formula which will return Red, Yellow, Green and Blue if all the children are the respective colour. =IF(COUNTIFS(CHILDREN(), "Red") = COUNT(CHILDREN()), "Red", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green",…
-
Changing a cell value, in a drop down column
Hi everyone, can anyone help? I am trying to change the Status of an activity from the Check box Step completion. I have Sales Step 1-6 in a drop down column, and I have Columns 1-6 as checkboxes. I want to check Step 1 to move the cell value to Step 2, Check step 2 to move the cell value to Step 3 etc.... I am struggling…
-
I am trying to count the number of cells that meet two different criteria.
My first formula counts the number of agreement that haven't been signed, but excluding "_signed". =COUNTIFS({Future Agreements Tracking Range 6}, NOT(CONTAINS("_signed", @cell))) This works fine I can also count the number of agreements that are renewals =COUNTIFS({Future Agreements Tracking Range 1}, "renewal") However,…
-
Two Levels up PARENT formula
HI THERE! Would like to ask if there is a formula that allow us to access the parent row but always the level 2 hierarchy. Normally, PARENT() solves the inmmediate parent only. Much appreciated.
-
Countif w/ multi drop down
Hi, I have a list of drop down items: I am trying to total the amount of those selected on another sheet. (How many rows contain those three items bundled together). I am getting an error message when I try: =COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, "FMLA" AND "CFRA" AND "Wave Parental Leave")…
-
JOIN/COLLECT when referencing a Dropdown (Multi Select)
I am trying to use a conditional IF based JOIN/COLLECT to generate a phrase in another column for notification purposes, but the column that the JOIN/COLLECT is referencing is a multi-select column and I can’t figure out a way to join multiple items from that column together. The column of interest is a list of possible…
-
Joining cells of multiple columns into one cell
I would like to gather the row responses in the columns outlined in red into the column outlined in green so that I can display just one column in a report instead of several. I have the following format I am starting from. It works well for rows with only one response to gather. It doesn't work for instances where there…
-
Max Function but with Text
Hello Smartsheet Community: I want the Overall column to look at Issue A, Issue B, Issue C and Issue D and return the highest level. The levels are No Deficiencies, Low, Medium and High. Is that possible with text? See screen shot. I know I can do this if I made High = 3, Medium = 2, etc. and only had numeric values in the…
-
Calendar View in a Report
I have our main schedule linked out to a report so we can filter each locations calendar. On the computer I can view everything correctly when I filter out certain locations. However, on the mobile app only a few of the events will populate. I have tried formatting the column to make sure they were all dates and filling in…
-
If(AND Statement between 2 Sheets
I have a form that is filled out by a handful of managers through our organization. I am working on creating a roll up to confirm that the form is completed by each person each month, and link it to an automation. I was trying to do a if and statement, then build automation based on that. For Reference {Manager Form} is a…