-
Which formula should i use to tally up the total amount of t-shirt sizes?
Which formula should i use to tally up the total amount of t-shirt sizes? I've tried different variations of sumif and countif but i cant seem to figure it out. For example: My column name is Quantity/sizing with all of these different size quantities: XS - 4 (I want another column with a shirt sizes calculated Total:…
-
INDEX & MATCH function showing "#INCORRECT ARGUMENT SET"
When trying to run this it shows "#INCORRECT ARGUMENT SET" error, not sure where i went wrong. =IFERROR(INDEX({East - Service Status}, MATCH([Ticket No]@row, {East - Service Range 1}, 0)), IFERROR(INDEX({South - Service Status}, MATCH([Ticket No]@row, {South - Service Range 1}, 0)), IFERROR(INDEX({Tamil Nadu - Status},…
-
How to compare SIMILARITY not exact match in a string of text/description/summary
I am trying to create a formula that compares a New Intake Form's description/summary to completed and Archived Intake Work Form's to see if this is a project similar to what has already been worked on in the last 5 years. I am not looking for an exact match, but something similar enough to pull the Old "Intake Request ID"…
-
Looking for a means of keeping an updated "automatic" inventory
Is there a formula I could use that would: 1.) When "Complete?" is checked on the right side… 2.) Subtract the "Units Requested" with respect to "Lot" from the left side and populate the "Remaining Inventory" The idea is to have a master inventory sheet that will show remaining inventories while having a secondary sheet…
-
Individual Cell (Not Row or Column) Conditional Formatting
Greetings, I am new to Smartsheet and am looking to change conditional formatting on individual cells (NOT the whole row or column). As I track products being produced in our plant, I want to be able to have the individual cells for the Start Date column turn green once the date is 'in the past'. Here is an example of what…
-
Populate calendar holidays given an agent list and the company holiday calendar sheet
Hello Dear Community, I have a situation with a leave calendar in Smartsheet, I need to add all holidays for the agents given the office/location, I have the list of agents with the 3 digit country code and a list of holidays with the same 3 digit country code, description and date, I want to populate all dates for each…
-
Need Formula to capture all instances of text alone or with other text in a column
Currently using this formula to count all instances of a matching status with EBIT division. Sometimes EBIT is not the only division listed in the column. So a cell might have EBIT TBI. This formula works only if EBIT is alone. =COUNTIFS({Status Phase}, [Primary Column]@row, {Sponsoring Division}, "EBIT") I tried adding…
-
I am getting an invalid data type when the IF function pulls the false statement which is blank inst
=SUM(IF(AND(YEAR(INDEX({Draw 1 Date Received}, MATCH([TK ID#]@row, {FEE TKID}, 0))) = 2024, MONTH(INDEX({Draw 1 Date Received}, MATCH([TK ID#]@row, {FEE TKID}, 0))) = 11, DAY(INDEX({Draw 1 Date Received}, MATCH([TK ID#]@row, {FEE TKID}, 0))) < 15), INDEX({Draw 1 Received}, MATCH([TK ID#]@row, {FEE TKID}, 0)), ""),…
-
Creating a Unique ID (YY-###)
I'm looking to create a unique ID per entry as YY-### that will reset each year (24-001, 24-002, 24-003, 25-001, 25-002 etc) Row ID: (auto number column) YYYY: =YEAR([Date Submitted]@row) YY: =RIGHT(YEAR([Date Submitted]@row), 2) Entry ID: =YY@row + "-" + IF(COUNTIFS(YYYY:YYYY, YYYY@row, [Row ID]:[Row ID], <=[Row ID]@row)…
-
Using IF with CONTAINS and AND for multiple columns
I am looking at two different columns - one is called Status and the other Priority. I would like to have a formula/function setup that will look for "Open" within the Status column and "High" within the Priority column. If it finds "Open" and "High" together in any row, I want a "True" value returned. This will be used in…
