-
I have a column of Filed dates and need to count how many fall within a given year.
I've tried several examples that I've come across here but most of them just give a formula without explaining what the components are so I'm having trouble adapting it to my purposes.
-
Column Formula to return 1st, 2nd, 3rd, etc. instance of a column entry.
I am looking for a Column Formula that will return the 1st, 2nd, 3rd instance of a column entry. The following cell formula works, but I am not able to make this into a column formula and need it to be a column formula so that when our form users submit a new form the Delivery Count column automatically updates. This is my…
-
COUNTIF leads added last week
Good day! I'm working on this new KPI report for leads added last week, and I'm using this formula: =(COUNTIF({Aldo Aguilar - Pipeline Range 1}, "2 - Upselling", "4 - Lead Generation", COUNTIF({Aldo Aguilar - Pipeline Range 2}, WEEKNUMBER(TODAY(-1))))) But at the moment that I hit enter, it returns "#INCORRECT ARGUMENT".…
-
How can I get a 2 digit month to appear with the following formula
Here is the current formula. =IFERROR(YEAR([Close Date]@row) + "-" + MONTH([Close Date]@row), " "). The results of this formula are causing sorting errors. I would like the result when the the month is less than 10 to appear with 2 digits. For example, the current result for September 2022 is 2022-9. I would like it to…
-
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…
