-
COUNTIF(DISTINCT
Hello Community, I am attempting to count unique numbers in one column if the code in the other column is "X". =COUNTIF(DISTINCT([Claim Number]:[Claim Number], [Contract Type]:[Contract Type], @cell = "LW")) Claim numbers are formatted as letter and numbers. Each part work fine separately, but not together. What am I doing…
-
How do I enter criteria to return specific results, but not using filters or dynamic view?
I'm curious if anyone has an in-sheet solution for this. I have a lot of data related to store information (store #, address, software versions, regional manager name, etc.). It encompasses all information about a store location and there are over 1800. Is there a way to build a sheet so you can type in the store # and…
-
Countifs across multple sheets with a Checkbox
I'm new to smartsheets, just getting my feet wet at thsi point. I could use some assistance with my Countifs expression which is across multiple sheets. My first expression: =COUNTIFS({JAILS: Individual Bookings Arrest}, $[Column 11]@row, {JAILS: Individual Bookings ArrestDate}, >=DATE(2022, 8, 26), {JAILS: Individual…
-
Smartsheet percentage
I'm looking to add a percentage column in my Smartsheet but every time I do it gives me the opposite information. An example is- I would like it to say 0% since there are only 2 samples and both had issues.
-
SUMIFS/COUNTIFS Date Issue
Hi all, I am attempting to create a formula to add up all the Employees from a sheet from last month. This sheet is pulling in totals on an automation monthly. The formula works except the Month section keeps making it 0 when I see it should be a 1. I have a similar issue with a COUNTIF formula. Can someone tell me the…
-
Making an order request form but need the ability for multiple items entered into the same order
I work at a manufacturing company, and I am creating a request form for our parts department. The way it is intended to work, is our Maintenance Technicians fill out a form with basic information (their name, part number, priority level etc.). This form notifies the parts department to check into the order and then sends…
-
Countifs formula for tickets created within a month
Hello, I have a situation where I am trying to count tickets that were closed within the same month they were opened. I have a status column, a created date (automated from the system) and a completion date. I am using the formula below but the system is giving me a value that I know it is not right. I am thinking I need…
-
SUM not totaling negative numbers correctly
I need to use a formula to get the totals for 4 cells that contain formulas. I have used the SUM or AVG function on this sheet for the same purpose and it has worked fine. Now it's not working and I'm wondering if it's because I'm trying to add negative numbers. Anyone know how to correct the total cell formula so it…
-
Manual Override of Formula Index/Match for Out of Office with Column Formula
Hi All, I have an index/match pulling in data relevant to a Business Unit from off sheet. I need to get it so that I can override this formula data to be blank/allow entering of a different email address by the sheet user. What I have setup already (working with Column formula): 1) User inputs Business Unit (BU) 2) BU auto…
-
Need help with AVG(Collect - multiple criteria same column
I'm trying to use Avg(Collect to get the average number of days from another sheet. My problem is I need to search one column for 2 key words. Is Avg(Collect similar to Countifs( where you can't do this? The below formulas work (XXX is a holder) separately but I'm at a loss for how to combine them to yield the correct…
