-
Excluding and Including data in a countifs formula
I need the total number of that meets the following criteria - Banner Name, Open, and not MA or NY. I am able to write the countifs to include the specific banner name and whether the status of that site is open, but I can't figure out how to exclude certain states or include certain states. This is what I tried below…
-
Parent Child Numbering
With A LOT of help from the community I was able put this together but, I think there must be a better way. The last column is what I am trying to get to. Auto-generated Sequential number in this format T-00001 when Ancestors = 0 Auto-Generated Sequential number in this format T-00001.1, T-00001.2 (where T-00001 is the…
-
Formula to extract a portion of a name
Hello,, In Excel I would use text to columns to do what I'm trying to accomplish here but I would like to try a different approach. I'm really close but seem to have hit an impasse. I have a name column that is formatted thusly Lastname, Firstname MI. where some employees do not have a middle initial. I want a column with…
-
SUMIFS - multiple criteria refrencing another sheet
Hello - I need help with a SUMIFS formula referencing another sheet. I would like it to sum the tech count column if the request type is "FSA" and the FW01 column is "true" Here is my formula that is currently not working: =SUMIFS({Tech Count Range 1}, {Tech Count Range 2}, "FSA", {Tech Count Range 3}, "true"}) Tech Count…
-
IF(OR(AND?
I am having trouble with a formula. I am not sure what the heck I am doing wrong here, but I know there are some formula geniuses here that can help me lol. I am trying to return a Red ball if the category is an output or project and the expected completion date is in the past. If it's not, I want it to pull whatever is in…
-
Combine two separate contact cells into one cell.
With the new update to Vlookup adding contact list functionality, would there be a way to combine two individual contact cells into one cell with both contacts using an equation/formula?
-
Is it possible to create an "If" statement that includes a hyperlink?
I have a column of data which reflects the status of a project. Statuses include "Completed", "On Next Report" etc. I'd like to embed the report schedule into the cell when the project status is "On Next Report" so viewers can easily click and see when the next report will be published. In my head, this is something like…
-
How to use vLookup for other sheets
Hello, I've been trying to use vlookup to find data from a datasheet Sheet A contains a column 1 with "My Name". Sheet B contains column 1 with "Name" and "Number" I want a column in sheet A that looks for the corresponding name in sheet B and returns its number. I've looked up tutorials on this but there doesn't appear to…
-
How to compare 2 sheets and harvest data from one sheet onto the second sheet
I am comparing 2 versions of a product BOM(one is flat, and the other is organized by sub assemblies and lists critical components). Each BOM is stored in its own Smartsheet Grid. One BOM has vendor and vendor part number information. I want to harvest the vendor and vendor part information from one of the BOMs and insert…
-
What formulae touse to get the count of status of A In Progress/Not Started and the same for B
