-
Formula to identify the task name of next child task due
Hi! I've looked at past posts to try to figure this out, but nothing seems to work. I'm trying to get a formula to work that will show me, in my parent task row, the Task Name of the child task that is due next, and then the due date of that task. In my screenshot example, i would want the formula to return Task 5, and its…
-
Need formula syntax help resolving unparsable error
So, not going to lie, I had to resort to chatgpt for this one after spending 2 weeks, banging my head on this (Got in over my head skill-wise with this one). I've already resolved a few issues I identified using answers to other questions here, but now I'm stuck. I think it has something to do with the nested OR() AND()…
-
Stumped: COUNTIF Formula for 4 criteria and 2 ranges.
Hello! This is my first time utilizing the Smartsheet Community 😊 I am trying to develop a report that highlights the number of requests across four different categories (RFPs, New Programs, Funding Rounds, and Rolling Applications) within four fiscal quarters. So ideally, I want a formula on my sheet summary to tell me:…
-
Formula to identify the task name of next child task due
I'm trying to get a formula to work that will show me, in a specified row, the Task Name of the child task that is due next. Formula: =IF(AND(COUNT(ANCESTORS([Task Name]@row)) > 0, isParent@row = 1), IF(COUNTIFS(CHILDREN(Status@row), "Complete") < COUNT(CHILDREN([Task Name]@row)), INDEX(COLLECT(CHILDREN([End Date]@row),…
-
Setting Up If Statement with 3 Parts
I have a status column where I want the 3 options to be "Not Started, Work in Progress, or Complete". The "Not Started" status would come from the Comments & Date Closed column being blank. The "Work in Progress" status would be based on there being comments added, but the Date Closed has not been filled in. The…
-
Countifs Multiple Criteria
I'm trying to count all the "Reserve" jobs for the year 2023. it's reporting 0. What am I doing wrong. =COUNTIFS({NEW SALES - DATABASE Range 2}, "Reserve", {NEW SALES - DATABASE Range 1}, (IFERROR(YEAR(@cell), 0) = 2023))
-
#UNPARSEABLE error in COUNTIF formula with OR function
Hello, I am unsure why this formula is returning #UNPARSEABLE. =COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR(({Task List - Texas Projects Agent Status}, @cell = "Red"), ({Task List - Texas Projects PM Status}, @cell = "Red"))) It is supposed to count the number of times a name in the "FND…
-
Can you have two "OR" functions within a COUNTIFS formula?
I am trying to count a column based on data that is in two other columns. Each of those columns could have different information so I am trying to use a OR function but I am running into a couple roadblocks. Scenario: I want to count the row in column A if it equals "IT" and if column B equals "Apple or "Orange" and if…
-
#INCORRECT ARGUMENT SET error
Good afternoon, I have been getting #INCORRECT ARGUMENT SET error when using this formula: =IF(AND(Category@row = "Demo account"; [Custumised timeframe]@row = "No"); Submission@row + 30; ""; IF(Category@row = "Content contributor"; [Estimated Editing end date]@row; IF(AND(Category@row = "External supplier"; [Custumised…
-
COUNT IF + NOT CONTAIN
I am using the formula below and the NOT CONTAIN is not working. Could anyone help? COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS(@cell, Maintenance))
