-
Submitting Multiple Rows using one Smartsheet Form
We are creating a new Smartsheet to track deliverables. We have asked competing vendors to add delivery details within a ‘Smartsheet Form’ to auto-populate the sheet. Orders contain 1 to 100 shipments. Our Order Number is the same for all shipments. Ideally the vendor would like to enter the Order Number and the Order…
-
Tutorial for users not builders
Hello, I'm creating smartsheets for my team, but they have never used smartsheets before. I'd love for them to watch a tutorial on the basics of using a sheet, but that skips all of the building/editing. They won't have to create automations or link anything; I've built all of that. They will just be responsible for…
-
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…
-
Core Product Certification Practice Exam Vs Real Exam
As anyone taking the practice exam and the exam itself to be certified? Do you feel the practice exam prepared you for the test? How similar was the practice exam to the real test? I know we get 10 tries with the practice exam so I took it without looking anything up to see how i would do, didn't pass but there was several…
-
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…
