-
How to calculate number of text occurrences in column and return a number
I am trying to calculate when a Y appears in a specific column and return the number 2 when this occurs and 0 when is N, any ideas on best formula have been pulling hair out!! Thanks
-
Having trouble using VLOOKUP formula in my Smartsheet
Hello Community, I have been trying to use VLOOKUP to cross check a screening date to what screening number was performed on that date, or within the date range; though I haven't been able to make it work! Please can you help me with what I need to do to make it work. My formula is: =VLOOKUP([Date of stock switchover]25,…
-
Lookup To Return Multiple Results
Hi - I've done some research, but am struggling to find the best solution on this one. I am trying to do a lookup from one sheet to another based on a Unique ID. A VLOOKUP returns only one result, but I'd like to return all of them back to one cell in the other sheet. It seems like some combination of COLLECT, JOIN, etc.…
-
COUNTIF function for the checkbox?
Hello all! I want to create a graph with checkboxes. Lets say I have some departments of: Governance / PMO M&A Communication Commercial and in my sheets I also have a checkbox column which is ticked based on whether they need support on a project. I am trying to figure out how to use the countif function to count the…
-
How to count tasks occurring over a date range based on another column parameter selected
Trying to set up a formula to count tasks happening during a date range based on another cell drop down ie approved, not approved etc, any ideas? Thanks
-
Count file names only
I'm trying to create a unique ID for documents. I would like to generate a unique number for each Category (in "Abv") but I'm struggling to not count the parent rows. My current formula is: =SUM(COUNTIFS(Auto:Auto, <Auto@row, Abr:Abr, Abr@row) + COUNTIFS(Auto:Auto, Auto@row, Abr:Abr, Abr@row)) The formula abode had been in…
-
Why are my sumif values different on my "sheet summary" than they are on my separate sheet?
I have a sumif formula in my "sheet summary" that is giving me a correct value when summing my values on that sheet. My formula is: =SUMIF([Project Status]:[Project Status], "Active /WON", [Project $ Value]:[Project $ Value]) When I use the sumif formula on a separate sheet referencing the same data I am getting a much…
-
Column Formulas in SUMIFS
Hi there, I'm currently using a SUMIFS formula that is as follows: =SUMIFS({v4 Hours}, {v4 end}, MONTH(@cell) = 12, {v4 Group}, OR(@cell = "AD", @cell = "Freelancer")) I want to sum the task hours column {v4 Hours} if the End Date for the task is in December, and the group has one of 2 values. Each {reference} refers to a…
-
Help with formula using weeknumber
Hi all. I think what I am looking for is a weeknumber formula, but I've having trouble figuring out how this will work. I have a sheet that lists 31 "fundamentals" of our company. Each week we have a different fundamental to focus on and will be discussing said fundamental at the beginning of meetings. I have sheets for…
-
Is there a formula where I can identify first item alphabetically in a list?
For example, if I have a list of names and projects, I would like to identify the first name alphabetically for each project. In the image attached, Alex and Jane should be the first people alphabetically for their projects. Is there a formula that could evaluate a text range and determine which value is first…