-
Creating WBS formula for deliverables spread out over phases
I have a project schedule that is organized by phases. Tasks for each deliverable are spread throughout the phases. The team has requested we add a WBS ID to the project schedule so we can identify/track the work across the phases. I'm trying to create a formula to generate the WBS. My formula to create the WBS Phase - 0…
-
Count the number of times a person's name appears in an "Assigned To" column
I currently use the below formula to count the number of times a name appears in the "Assigned To" column. The issue is that this column can have multiple names in the same cell, so I have to created a separate formula for every possible name combination. Is there a way to have a formula that looks for a name string and…
-
Formula to calculate amount of days/weeks/months between two dates?
I work in managing long term, in vivo research studies so keeping track of age is important, I am assuming this is a pretty basic formula but I cannot seem to figure it out. I also want an automatic column that just gives me current age. Please help!
-
#Nested Criteria when combining formulas together
I am trying to get this formula to work, but it kicks back the nested criteria. =JOIN(DISTINCT(COLLECT([Employee Number]:[Employee Number], [Created Date]:[Created Date], IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), [Employee Number]:[Employee Number], COUNTIF([Employee Number]:[Employee Number], @cell) >= 2)), ", ") I just…
-
Need help with formula on helper sheet to pull specific data from other sheet.
I have a sheet where employees submit information to me. I created a helper sheet because I want to see all of the employees who submitted requests 2 or more times in the current month. Is this possible to do?
-
Use formula to capture data but then not update
I want to use a simple Index Match formula to capture data from another Smartsheet, but the issue I have is that the data on the other Smartsheet will be updated throughout the year. I do not want my data to be updated as the other Smartsheet is updated. For example, I have a list of contacts that will get updated if…
-
Formula help with Index Match and Contains
Here is what i have in 2 ways but neither work: IF(CONTAINS("X1", [Model Type]@row), INDEX({Other Sheet Range}, MATCH([Email 2]@row, {Other Sheet Email Range}, 0)), "") IF(CONTAINS(INDEX({model}, MATCH([Email]@row, {assignee}, 0)), "X1"), INDEX({serial number}, MATCH([Email]@row, {assignee}, 0)), "") My goal is to retrieve…
-
Join Collect formula that excludes the current row from the results
I'm trying to create a formula that creates a list of duplicates in my sheets, I've gotten this formula to work but it's showing the original row within the list of duplicates. I tried adding an auto number column and including a condition that the list shouldn't include the current row. However, the addition of this to…
-
CountIFS with multiple criteria in second range
Looking to capture the certain status of a Purchase Order in a list of orders associated with several different projects. So i have range 1, criteria 1 = "Red", Range 2, Criteria 2 = Multiple project numbers. Keeps returning unparseable or incorrect arg. Is there another formula I should be using?
-
Lock or Store Date/Value Solution without using Zapier
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
