-
Sumifs not working between cross sheets
I am trying to add up a value if 2 criteria are met. I want to add the value of "Change Order Amount" if "Owner Approval" is "Yes" and it is "Cost Code" "1-Overhead" HELP
-
Setting up a sheet with names
How can I have a calculation sheet where all the names of the main project sheet will appear on, automatically? So for example, someone new has joined the project. They have a task now, on the main project sheet. I would like this person's name (so they are in the "assigned to" column) to show up on the calculation sheet…
-
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…