-
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…
-
Control Center: Adding new sheet to provisioned projects using Optional Templates, broken formulas
I have a new sheet I want to add to an already provisioned project in Control Center but all the formulas return broken. I have created the sheet in the blueprint and have saved it as an optional template. This optional sheet is linked to other sheets in the blueprint (it is a summary of data linked to source data - for…
-
How do I create a predictive balance formula?
I'm not sure if this is even valid/possible, but I'm trying to create an accounting schedule which foresees upcoming payments and reflects the balance after the transaction. This image is a practice sheet with fictional values. In theory, I'd want the formula in Balance to always take the previous balance and add it to the…