-
Nested If with Multiple Conditions Automation for Project Management
Hi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started") I just…
-
NEW ZEALAND TIME ZONE & TODAY() function mismatch
Hi Smartsheet Team , I have an issue with the Today() function not reading my date correctly . I contacted you and you provided me with a long formula to overcome this but it still didn't solve the issue for us . The formula i'm using now is : =IFERROR(IF(AND(ISBLANK([Resolved Date]@row), [Created Date]@row <= TODAY()),…
-
IF AND Function For Reporting
Hi guys, I am trying setting up a new report for my team which will allow them to bring through project activities based on the following criteria: * The week the activity happened in is before today's current week. * The RYG status is red OR green OR yellow I am using a column set up as a checkbox and trying to put an IF(…
-
Countifs function to count ratings by location within the past 7 days
I am trying to create a countifs function to count 5-star ratings by restaurant location published within the past 7 days. The published column contains dates. So far, I have this equation: =COUNTIFS(Rating:Rating, =5, Location:Location, "Bayshore", Published:Published,AND(@cell <= TODAY(), @cell > TODAY(-7)) I am getting…
-
#INVALID DATA TYPE when using COUNTIF Formula
Hey Community - I am having an issue trying to use the COUNTIF formula. In this use case, I basically have a formula in the first column to show if start and end dates match with other columns in the sheet. All I want to do is count the number of "Yes" cells, but when I try to use the COUNTIF formula, I get an #INVALID…
-
countifs + find formula with multiple criteria
Hello, I'm fairly new to smartsheets and trying to solve a roadblock. I'm trying to count the amount of times a specific string is in a cell with two types of status: closed and submitted. I'm using the FIND because some cells contain more than one ticket # (i.e. "Ticket-432, Ticket 12435") =COUNTIFS({Database Range 1},…
-
Count of All Items, where Start Date is less than Today
Hi, I am trying to get a count of all Task Named: "To Do", where "Start Date" is less than Today's date. I am using: COUNTIFS(Task Name, "To Do", StartDate, "StartDate < Today()"), for this, I keep getting '0', but I see there are at least 4 tasks meeting this criteria. Any help if very much appreciated. Thank you, Deepthi
-
Count all cells in a column that are NOT blank and do NOT contain a date
Hi, I want to create a formula in a date column that allows me to count all of the cells in the column that are not blank but do not contain a date. I have tried various COUNTIFS but can not seem to find the perfect solution. Thank you for your assistance.
-
Flagging task if not updated
Hi, I have a sheet that tracks a group of teams' weekly KPI's. Each week on a Thursday, the different team members need to access their sheet, update the date that their KPI's relate to and enter the KPI's for each line. Each team has a separate sheet that rolls up into a "AT RISK" task tracking report for me. I have to…
-
Counting a date diffrence with children
Hello, Does anybody know if there is there a way to make the below formula work? I'm not sure what I'm missing. I need a count of children where the difference between the task due date and the created date is 1 or less.This one has stumped me. =COUNTIF(SUM(CHILDREN([Due Date]8) - CHILDREN(Created8)), <=1)