-
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…
-
Formula to calculate the amount of "done" rows for different years.
We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter for jobs done in 2018 or 2019 etc? Kind Regards, Hugo Martinwall
-
Sum of a Cell Range, Dependent on a Dropdown Value
Is there a way to add up the total of a cell, dependent on the drop down value of the row? For instance... I would like to total the sum of the revnue (shown in the "Live Revenue Log") by the day (shown in the "Daily Revenue Overview")