-
Duplicate Row Column Formula?
Is there any way to flag a duplicate (only for the 2nd, 3rd, etc. duplicate)? I'd like to leave the first of an item but flag the multiples of the rows so that those can be deleted. =IF(COUNTIF([Task ID]$1:[Task ID]@row, [Task ID]@row) <> 1, 1, 0) is the formula I'm currently using but I want to have it setup as a column…
-
Creating a IF(AND(ISDATE formula to check a box
Hi All, I am trying to write a IF(AND(ISDATE formula to check a box I have read through several post but dont see and example of doing all three of these functions nested together. I get either unparsable or Invalid argument on my attempts. Goal: in my data set I dont care what the date is just that it is a date (anydate)…
-
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),…
