-
Can INDEX / MATCH join more than one item?
The INDEX / MATCH works when I want to match each name with one team... but if I have all three names in one cell, can I get a return of all three teams associated with each name?
-
Contact Support Page not working? Having cross-sheet formula issue
Two issues here: #1 - Anyone else having issues with the Contact Support Page? I keep filling out the form and it's going nowhere? No field errors either? It's been 2 days now with no luck so hopefully can get some help here. #2 - Cross sheet formula Issue i'm experiencing. I have 3 sheets - one is a data source sheet, the…
-
Compare two dates in the two cells.
Hi, I want to compare two dates, if the dates are different in the two cells I want them to glow red. What formula do I have to use and where to put it ?
-
Sumif Index Match multiple criteria
Hi, I would like to add the quantity in another sheet if they match 4 criteria in my sheet. For instance; I would like to add the quantity (from the Orders Sheet) of material ordered for each item in the Costing Sheet, to compare with what we costed on. Below is the Costing Sheet, so I would like to add up the quantities…
-
Assigning Contact Based on data in another sheet
Here's the rough scenario. I have 500 students who are divided up among 20+ teachers. When I choose a student in one column, I want to auto-assign their teacher in another column. I do this in Google Sheets with a formula, but wasn't sure how to go about it here. Let me know if you need more clarification. Thoughts? Gillian
-
COUNTIFS formula between a specific date range
Hello SmartSheet Community! I am trying to write a formula that will capture project deliverables status between a specific date range and I keep getting an error. I thought the below formula would work, but I am wrong, lol. Any ideas? =COUNTIFS(Status:Status, "Not Started", ([Start Date]:[Start Date], >=DATE(2022, 10, 1),…
-
Formula for Join, Collect, and If Statement - Resources Availability
I have a sheet that contains my resources' availability for each week and I'd like to pull in a list of those that have availability into another sheet so we know who to assigned to tasks on a project. I figured out the Join(Collect) part of the statement but I need to get the IF statement to work. Please see below for how…
-
Multi-select fields with INDEX/MATCH (or COLLECT) with multiple values
Hello fellow Smartsheet users! I am running into unique problem and more importantly finding the way to do something within Smartsheet. A little background. I build a request intake/workflow management tool for my Marketing department at a global organization. Users make Design, Content, Web, and Video requests through…
-
can forms have totals?
I want to add to a form a section that asks people for amounts and then totals it, is that possible? something like: blue widgets needed - # red widgets needed - # green widgets needed - # Total widgets = # blue+# red+# green
-
Formula for multiplying with rounding included
Okay, so I need to come up with a formula that does 2 things: Multiples the numbers in ColumnA with the numbers in ColumnB Rounds those numbers up or down depending on what the nearest .5% is For example: ColumnA has 6 in it ColumnB has 70% in it Multiplying those together, gives me 4.2. I need that to automatically round…