-
SUMIFS with Multiple Criteria
Hi, I am trying to create a summary formula for Work-in-Progress (WIP) value on a KPI summary sheet, using data on a secondary sheet. I need the formula to do the following: * Only look up values that have a WIP% figure greater than 0 * If a WIP% figure is available, divide the total value by the WIP% * Add all of these…
-
Formula value
Hi, I have a job file that uses several VLOOKUP formulas to extract customer information, order and delivery date. When the task is finished I would like the information retrieved wirt the formulas to be embed in the task document so the task file can stop looking for the information. I currently use the Paste special but…
-
Insert row does not auto-fill
I thought this worked before, but maybe I am mistaken. When I insert a row (using the right-click menu, the row drop down, or the insert key), the formula from above and below the new row do not auto-fill. I really don't remember seeing that before. Craig
-
Where is referenced field
Ok, first, I took over this sheet, report, dashboard from a former employee and out of nowhere a sheet stopped working. I know the problem, just trying to determine how this happened and how I can fix it. There is a cell with a formula. The formula references a field in some other sheet. How can I determine where it is? If…
-
if text in column a is "X" then apply numeric value to column b..help?
Hello! I apologize in advance as I'm sure this is super simple, but for some reason I'm having a hard time and frankly have spent too much time (staring at it, searching formulas, trying+ failing etc ;) ) when I'm sure you smarties can help! What I'm trying to do: if text (a specific text/phrase from a dropdown option) in…
-
Formula to add multiple dropdown with a criteria
Example Column 1 banana orange watermelon Column 2 kid 1 kid 2 kid 3 I want to create an equation that counts, how many times kid 1 has chosen banana and orange???
-
Add two values in the one colum
Hi, I am trying to add two different values from the one column in the sheet summary and keep coming up with an error =SUM(COUNTIFS([Lease Due In]1:[Lease Due In]130, "Due in Next Month", COUNTIFS([Lease Due In]1:[Lease Due In]130, "Due in Next 3 Months"))) The error is #INCORRECT ARGUMENT SET I have tried a few different…
-
What is wrong with my nested IIF THEN ELSE statement?!
I typically do not have issues with calculations - I am sure that this is a really stupid mistake I am making - but what I am doing wrong with this nested IIF THEN statement?! iif ([Data Type] = "Income Statement" THEN iif([Data Type]="Net Sales" THEN [Value] else "" END))
-
Month/Year Row Count Function
Hello All, Can someone help me figure out why this formula is not working anymore? =COUNTIFS({OSPO Engagements Archive complete date}, IFERROR(MONTH(@cell), 0) = 1, {OSPO Engagements Archive Hierarchy}, =0, {OSPO Engagements Archive complete date}, IFERROR(YEAR(@cell), 0) = 2019) It used to count all of the rows for a…
-
Nested If Statement or vlookup
I need some assistance with a formula, if possible, still fairly new here. We have two sheets that need linked together but I'm not sure to use an if statement or vlookup. Our Service Team orders parts through a form on the "Non-Stock" Smartsheet (they love it! compared to our old system) Shipping and Receiving records…