-
VLOOKUP with multiple criteria
I have a VLOOKUP formula referencing another sheet and it works great. The problem I run into is when I need the same formula to look up multiple criteria before returning a value. Current formula (works): =VLOOKUP(Date@row, {BYP RSS Links}, 7, false) I want everything in the formula to remain the same, except I want it to…
-
Index Match Function Not Working
Hi, I have an Index Match Function that is only working for some of the rows and coming up with a "NO MATCH"" for others. It doesnt make any sense to me as it is referencing Auto Numbers that are clear and easy to match. The formula is: =INDEX({Contact List Name}, MATCH([Company Index]@row, {Contact List Index}, 0)) Source…
-
Help to count a column where neither 'Complete' 'Canceled' checkboxes are selected
Hi all, I am trying to build a formula that references another sheet, mostly focusing on 3 columns in that sheet: At Risk (symbol) | Completed (checkbox) | Canceled (Checkbox) I am trying to count all the values in the At Risk column where neither Completed or Canceled checkboxes are selected. Basically, I'm trying to…
-
Issue using COUNTIF function with OR condition where OR is reference to different sheet
I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error. Formula that I am using is =COUNTIFS({Primary_Owner},…
-
Check a Date Range
I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days. For example: “Date” = 07/10/22 Today’s Date = 07/22/22 Is the “Date” within the range: 07/01/22 –…
-
Which count formula do I use?
Hi, I have two sheets. The first sheet changes daily the words passed or failed depending if the item passed or failed our process. On the second sheet I need a daily count of how many items pass and how many items failed. This sheet needs to updated daily depending on how many passed or failed their are. I've been reading…
-
Want to count number of instances in a column
HI There, I have one column in which I track the status of each row with a traffic light (Red, Yellow, Green). I would like to count the number of Red's, Yellow's and Green's in the column so I can use this information in a dashboard/portal to show the number of each color/status. I have triied a few things, but I am…
-
SUMIFS total for data within last 30 workdays
Hello, I've read multiple questions regarding getting a return of SUMIFS for a set date range. I however can unfortunately not seem to get my function to work. I am attempting to get a sum on the total number of orders done within a specific hour over the last 30 days. I have a form that feeds in data that tracks orders…
-
Sum of data between dates
Hi, Hope someone can help me, if this is at all possible. I have a request form that my users use to request ink and I would like to use a formula to show me how much we have used for each Ink type per month or during the last 30 days. Below is my sheet which when a user requests ink it auto fills a request date field and…
-
Is there a formula which can capture information from from a rolling 12-month period?
I need to set up some cross-sheet formulas to capture how many machines we have installed over the past 12 months, broken down by each month - however I want this to be a rolling metric which only captures the information from the past 12 months - is this possible using a Smartsheet function, and if so please could you…