-
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…
-
COUNTIF dates within the next year.
Hi There! I'm new to formulas and have tried lots of different ways to solve this, and still haven't managed, so any assistance would be appreciated. I want to count each Event Type which starts within the next 365 days. I have managed to count the total number of each Event Type in the column by using: =COUNTIF([Event…
-
Sheet Formulas Not Auto Updating
Just recently I noticed that the formulas within my sheet are not working in the background and updating my reports as they used to. I have a formula that populates a status based on a date, so if the date is in the past, it marks the status complete and then my report only pulls tasks that are not complete - I only have…
-
[Help] Change the value of the value of a parent row depending on the statuses of their children
Hi Everyone, I've seen many articles about this, but i can't seem to figure out how to do this. I have a row with the name of the project (PARENT) and, indented in it, rows that are tasks part of that project (CHILDREN). Also, there's a column called Status, with 3 variables as a dropdown menu: Awaiting In Progress…
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…