-
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")
-
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…
-
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!
-
Nested IF Statement Formula
Hello Team, This would be a great formula to incorporate into my daily SmartSheets process within my organization. I would like to know how to create a nested IF statement if this is the correct formula to use, that uses an RYG (red, yellow, green) light flag formula to set the status of a task based on its…