-
Joining multiple COUNTIFS statements
Hi there. I'm trying to create a single formula that will count items in a column on sheet A if they fall between two dates and also count items on sheet B if they fall between two dates. The item name is the same in both sheets and the date ranges are the same in both sheets. The formula I have (which does not work) looks…
-
Why am I getting an INVALID DATA TYPE error?
Here is my formula, which references another sheet. All referenced columns are the same type (drop-down) =COUNTIFS({Lead Category}, OR(@cell = "Lite Upgrade", "@cell =New Lite Site"), {Sales Type}, "New Deployment", {Sales Tier}, "Experiencia") Thanks for your help!
-
Using a formula to subtract out a Contact
Hello, Is it possible to use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, will SUBTRACT that contact from the first cell? So in practice it would look like this: Cell 1: Contact1, Contact2, Contact3 Cell2: Contact2 Cell3: Use a formula that…
-
Struggling with formula that references status in another sheet
Hello Smartsheet friends! I have a sheet (called Test Receiver Sheet) where I want a box to be checked for each row if the client code for that row matches client code on the second sheet (called TEST Client Audit Form) AND the status is "Complete". This is the formula I have so far. Im getting an invalid reference error.…
-
I would like to make a column name equal to a cell.
I would like to make a “text/number” column name equal to the a cell located in the first row of the column, can this be done with a formula?
-
Join Collect multiple columns from another sheet
I have this growing reference sheet with Site_Name and respective emails (1-3). Not all of them have all 3 emails. Please also assume that the emails are not beside each other. They could be 2-3 columns apart. I need to merge their emails on this order tracker, but not sure how to use Join Collect if there are multiple…
-
Formula to Determine NEXT DATE from a group of Dates
I Have a series of Go Live Date columns in a Smartsheet and I want a new column called "Next Date" that determines which of the dates is the next Go Live date. I using the following formula but it doesn't return any value: =MIN(COLLECT([Release 1 Go Live]@row, [Release 2 Go Live]@row, [Release 3 Go Live]@row, [Release 4 Go…
-
#INVALID DATA TYPE error when IFs are combined
Hi all, I've got this formula here that basically enters name of the month in the cell based on date: =IF(MONTH([Date of Defense]@row) = 1, "a. JANUARY", IF(MONTH([Date of Defense]@row) = 2, "b. FEBRUARY", IF(MONTH([Date of Defense]@row) = 3, "c. MARCH", IF(MONTH([Date of Defense]@row) = 4, "d. APRIL", IF(MONTH([Date of…
-
I need formula to count everything but Blank cell?
The Black cells are blank cells. I need a couple of formulas 1-that will if me a total of non-blank cells. 2- be able to compare "MS" cells to the "SS..." cells. Im looking to create a dashboard I can use to display
-
If Statement for Colored Balls
Hello, I am trying to create an IF statement that says IF there is one or more red ball in the range below then the green ball turns red OR If there are one or more yellow balls I would like the green ball to turn yellow. Otherwise, the ball stays Green. So far here is a simple attempt just trying with the first portion of…
