-
Trying to check a box using OR
I want a box to be checked IF Sales Status is "Verbal Agreement" or "Deployment Prep Call - Scheduling" or "Deployment Prep Call - Scheduled" =IF([Sales Status]@row = OR("Verbal Agreement", "Deployment Prep Call - Scheduling", "Deployment Prep Call - Scheduled", 1)) I'm getting the error INCORRECT ARGUMENT SET. Thanks for…
-
Find the average of hours, minutes, seconds
Hi there, I am having difficulties finding the average of hours, minutes and seconds. I have 12 months of data for timings, and the format is in hours, minutes, seconds how it is in excel - 00:00:00. I have to find the average for each month, for an entire years worth of data, and it gives me an error when I look for the…
-
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…
