-
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
-
Show dates beyond 90 days
We need to report on Jobs that has not been touched in the last 90 days. When we start a new Job we copy 4 "template" rows which include dates in the future. When I run my current report, it looks for dates on the parent row, but this row is showing the oldest date for the children. If a job has not been touched for over…
-
Assigning numeric values to drop down menu options
I want to assign a unique numeric value to each of the options in a drop down menu column, and have that numeric value display in an adjacent cell. Drop down menu options in each cell are: Needs Contributor Contributor Reviewing Ready for Production If 'Needs Contributor,' is chosen, then adjacent cell is populated '1' If…
-
Function/Formula help to input Yes/No values as well as days outstanding based on two different scen
Hello, Can you please help me figure out formula's for the follow scenarios? I have attached a copy of my smart sheet that i'm needing to apply the formulas to. #1) PC Action w/in 5 days (Column F): If the date in column D (Date 1st update provided by PC) is less than or equal to the date in column C(Due Date) then YES…
-
Formula with OR Statement
Good evening: I am trying to add an OR to the formula below: =COUNTIFS(Priority:Priority, ="P1", Status:Status, ="Potential") Potential or Active Thanks for your help in advance!
