-
Looking for the most recent submission based off date
hello I am looking to build a formula that pulls the "Mid/ EOC Rating" from a reference sheet with the criteria that the ID's match, it is the most recent submission based on Evaluation Date, and that the Evaluation was an EOC not any other options So far I have gotten to the below formula but it is still reading as…
-
Checking off a box in one form when another is filled out?
Hello! I am very, very new to Smartsheet so please forgive me if this isn't the right place to ask or a dumb question. I am attempting to make a sheet that records when someone has filled out a form on another sheet. The original sheet is a form for a customer service survey, and the one I want to make records when and if…
-
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)), ""),…
