-
Counting by date
Hello, I have a sheet that counts sick calls for our colleagues. Currently I am utilizing a basic formula to count the number for said person, =COUNTIFS({WMS Name}, =[WMS ID]@row, {Absent Type}, ="SICK") This works for the initial- total count. But once they have surpassed the first threshold (5) a meeting will be held,…
-
IF / OR Formula issue
I have a ticket tracker that I need and IF, OR formula to determine if either field has a Yes. My formula works, but will only show Yes if BOTH of the other fields are Yes. I need it to say Yes if either of them are Yes. =IF(OR([Started MRR less than $500?]@row = "Yes", [MRR Change less than $300?]@row = "Yes"), "Yes",…
-
Without using Project settings/working days, (If date is a holiday, then.....) formula
This isn't working for me. I have holidays for the next two years in (Date Observed), then I have a series of dates for task or project due dates that can't be due on a holiday. I have this so far and it doesn't work: =if(or(Date@row=[Date Observed]4,,Date@row=[Date Observed]5,Date@row=[Date Observed]6,,Date@row=[Date…
-
Join collect with other sheet
I'm trying to use the best formula that will basically say.. If Distributor Name (sheet one) = Distributor Name (sheet 2), then input contacts (sheet 2) into contacts (sheet 1). There are multiple contacts on separate rows for each distributor on sheet 2 that I want to combine in a single cell for each distributor on…
-
INDEX/COLLECT Formula for gathering list of data
Hi, I am not sure if INDEX, MATCH or COLLECT will be the right things to use in this formula but I'm very much a beginner in using those functions. On Sheet 1 I have a massive list of Restaurants (Column 1: Restaurant Name). Also on that sheet is Column 2: Division (For example Tampa Bay Restaurant is in the Southern…
-
Count the number of "No" in the entire row across multiple columns
Hi, I have 45 questions in a survey in Smartsheet. So, that is 45 columns of questions. All the questions are single select "Yes/No/NA". One row of data equals one survey. Is there a way to count the number of "No"s in one row and put it in the "Failures" column? I am trying to get a count of the items that failed for that…
-
Trend Formula with R,Y,G balls
Good Morning Smartsheet friends, I am new to Smartsheet and have been working to learn as much as I can about this program. I'm trying to show my leadership the value in its usage. I'm trying to figure out a formula that will COUNT the number of weeks a R,Y,G ball is a specific color to show a trend. We track items by the…
-
Copy Row Automation
I am trying to copy rows over to another sheet once a date is reached and the respective review period has begun. The automation workflow I have is this: Trigger - When a date is reached Everyday at 6:00 am Condition - Where deadline is today Copy Rows I am not having any luck with the rows copying over to the other sheet…
-
Need a formula to count a multi-select dropdown cell if its contents include "has any of"
Hi there. New to Smartsheet so forgive me if this is basic. I have searched the forum but can't find the specific usage scenario. I am trying to create a Sheet Summary formula to count all the cells in a certain row [Tags] that contain a specific "tag" eg. "Mid-M". Seems easy enough but because its a multi-select dropdown…
-
Formula to count the how many times "Monday" is listed
This is for a ticketing system. I want to count the number of requests that come in on each day of the week. I am looking for a rolling YTD number. I have a metrics sheet that pulls the data from a closed tickets sheet. This is the formula I tried using: =COUNTIFS({Resolved Date Range}, CONTAINS("Monday", @cell)) Any help…