-
INDEX/MATCH find some but not all. Mixed numbers and letters in MATCH fields
Any ideas why I'm getting no results for 305WI001 and 209WI007? Here is my formula: =INDEX({DQDs in Review Doc Group}, MATCH([DQD No.]@row, {DQDs in Review DQD No.})) It seems the DQD No. with a "WI" returns no results but the rest do. I've checked my source data and there is a Document Group designated for both 305WI001…
-
Using the IF and FIND function multiple times
=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", " ")) The above formula works just fine. What I want it to do is look for certain initials and assign different modalities. For example, if the APPT LOCATION starts with "TH" it will assign Teams. So far so good. I also want it to look…
-
=INDEX MATCH .. formula
Trying to create a standardized process for setting up our construction sheet, contract, and change orders. I would like to be able to pull the client's contact info from one sheet ('Sheet Names') and have that information auto-populate back onto it's specific construction sheet, based on the project's address which will…
-
Formula on a Gant Chart
I have a production sheet for units to be manufactured with a Gant Chart and dependencies. I also have the total number of units to be manufactured as well as the value per unit on my sheet. I would like to expand my sheet to include the value of the units manufactured per day. Is it possible to add a formula onto a Gant…
-
Counting Number of Installed Stores
Hello Smartsheeters, I am trying to count the number of installed stores using Smartsheet. I was able to use COUNTIF to get the number of chains that are installed by parsing the "Status" column: =COUNTIF(Status:Status, "Installed") However, I have another column that lists the number of installed stores/branches per chain…
-
Unable to create absolute reference to a cell in smartsheet.
Hello, I am trying to create an absolute reference to the cell Test1 for example, where Test is the column and 1 is the row. In order, to make the absolute reference I add $ in front of the column name and in front of the row number, $Test$1. However, whenever I, for example, insert a row above that cell or sort the…
-
Formula Not Operating Properly
Hello, I am testing out the Construction/Facilities Management Template Set and I think the formula is incorrect in the sheet for the Schedule Health. =IF(State3 = "Complete", "Green", IF(AND(State3 <> "Complete", TODAY() > [End Date]3), "Red", IF(AND(State3 = "Not Started"), "Blue", "Yellow"))) The way it is currently…
-
Return rightmost non-blank cell value in a row?
Hello everyone, I created a more roundabout solution for this involving a separate grid, but I'm wondering if there is an elegant formula that would do the following. See first screenshot below. Without getting into too much detail, I am hoping for a formula to put into [2022 YTD]13 that would look at the values in [Q1…
-
Formula no longer working
I have had a formula written for over a year and it just broke this morning saying it is now an #invalid operation. =City@row + ", " + State@row + " / " + [Location Number]@row + " - " + [Comp Short]@row
-
¿Cómo calcular los días de retraso entre dos fechas??
Hola comunidad!!! necesito calcular los días de retraso sobre las actividades de mi equipo de trabajo, para ello necesito poner la fecha actual y restarle la fecha de limite, pero no encuentro la manera correcta de hacerlo :( alguien ha realizado algo parecido que pueda apoyarme por favor?