-
formula
Hi, I'm trying to get the FGT result looked up from the 2nd sheet if the article Nr match. I tried this =INDEX(...), MATCH([Article NR]@row, {.....}, 0)) But it gives me only the correct result, when only 1 article Nr is entered in sheet 2. How can I check all article Nr in sheet 2. I tried to combine HAS but I failed. I…
-
formula remove text /keep text in (...)
Hi Experts, I would like to keep only the text which is in brackets below. [clear onix/ftwr white/solar yellow (FY6226), orbit indigo/ftwr white/tactile blue (FY7852), ftwr white/solar red/iron met. (FY6218), core black/core black/dark grey (FY6222)] Result in the new column should be FY6226, FY7852, FY7852, FY6222 I start…
-
Index Match using two sheets
Hi! I am trying to use Index Match but not having a clear understanding of what it is I need to do is making it difficult. All I need to do is when I add the Reference Number, the formula should search sheet A and sheet B for the number and pull 4 columns of data based on this number. What I would like to be able to do…
-
Sumif date formula
Hi All After a sumif date formula- have tried a few but think my logic is off Sheet 1 has Date Invoiced Invoiced amount In Sheet 2 I need to sumif {Invoiced Amount} for year and month only - eg will sum all invoiced $$ amounts for the month of may
-
Combining multiple cells when one is blank
I am using this formula to combine cells in a single row to create a unique name/identifer. This formula works fine. =Suite@row + "_" + Offering@row + "_" + Module@row + "_" + [Additional Asset Name Detail (as needed)]@row + "_" + [Asset Type]@row + "" + "_" + FY@row Producing this result. MA_Test 2 offering_Test 2…
-
Counting Unique Data Only if Associated Column is Not Blank
Hello again! We really do research these things before we ask! ;) We are looking to count the unique Store Numbers for "P1 Complete Dates" and "P2 Complete Dates" in the Sheet's Summary Data, so we can make sure each store is only being counted once for each phase. The formula that we found and tried is only giving a…
-
Combining CONTAINS, with NOT(ISBLANK and NOT(CONTAINS
Hello Smartsheet Community! We have (3) columns: Country, Tracking, Project Status. We need to count the number of cells that contain "CAN" for Country, Tracking is "Not Blank", and Project Status does not contain the word "Complete". Below is what we attempted, but are unable to get a result: =COUNTIFS(Country:Country,…
-
evaluate if a cell date is weekend and convert its date to next weekday
Hi All, I am trying to add a number of days from a calculated cell to a date and deduce a new date (weekday). I am calculating the number of days based on allocation and adding that to the current date to get a new date. I need help to evaluate the result of function in current cell and increment the date to next weekday.…
-
Counting in a Summary field with multiple conditions
I need to use a Summary field to Count when the following conditions are met in a Sheet: If Indent Level = 3 AND End Date is between a specific date range (using TODAY), AND the job is not complete, AND the Task Owner is ANY of the following: CopyeditAMT@user.com or PadletAMT@user.com or LayoutAMT@user.com Here's what I'm…
-
Count between two columns if looking for non-blanks in one of them
Hi all. We have (2) columns: Tracking and Project/PO. We need to count all of the cells in "Tracking" that have a tracking number i.e. are NOT blank, but at the same time NOT counting any cells from a row that also contain the word "Lab" in "Project/PO" These are the two versions we have tried, based on other similar…
