-
Identifying When Subtasks are Ready for Execution Based on Status of Other Subtasks of Same Parent
Hi - I've seen similar posts for related activities (mostly updating the parent's status), but need help finding a solution to my use case: Background: We have different test scenarios, each with a parent and associated child tasks. The child tasks of a given parent need to be executed in the order they fall. The number of…
-
COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
-
IF, AND, ISBLANK formula
Here is the scenario: If Cell A is BLANK, the value of Cell B is TEXT, what is the NETDAYS between Cell C and Cell D? =IF(AND(ISBLANK([CellA@row), ([CellB@row = "All Comments Resolved")), NETDAYS([CellC]@row, [CellD]@row)) Please help!
-
IF and ISDATE Formula
I want to calculate NETDAYS from Submission Date to Todays Date, or to Comments Log Received Date I have this formula that works. =IFERROR(IF([Comments Log Received]@row = "", NETDAYS([Date Submitted to SJTA]@row, TODAY()), NETDAYS([Date Submitted to SJTA]@row, [Comments Log Received]@row)), "") However, I need to expand…
-
Formula - Helper Column Flag if Duplicate
Is there a formula I can use in a helper column to flag an entry if a duplicate already exist? We are going to share add forms with 100+ people to enter information about their employees. The last time we did this many of them entered duplicate employees causing a lot of chaos. The goal is to send out alerts/notifications…
-
Why is this #incorrect argument set
=SUMIF([Task Status]:[Task Status], "Completed", [Contact(s)]:[Contact(s)], " ricky torres ") I'm trying to show the completed tasks in the contacts column, and specifically for the contacts individually.
-
Date Formulas
Hello Everyone, I'm new to the smartsheet community, but have been using smartsheet at a basic level for a few years now, and I am looking for some help. I have a form that collects information for me. Each time the form is completed and submitted it creates a new row in my sheet. In my sheet, I have a column called an…
-
Trying to return the date if a certain row task is marked Complete
After spending some time learning about a bunch of different things in Smartsheet that aren't helping with my problem, I thought I should just ask my question. I am missing something small I think. I have tasks in my projects that need to be completed after it is implemented. I want to capture the "Execution Complete" task…
-
Column has a formula, need answer as a multiplier
C Value column is a formula =IF(ISBLANK([Solution #31 Correction Factor]@row), "", IF([Solution #31 Correction Factor]@row = 9.5, "1.05", IF([Solution #31 Correction Factor]@row = 10, "1", IF([Solution #31 Correction Factor]@row = 10.5, "0.95", IF([Solution #31 Correction Factor]@row = 11, "0.91", IF([Solution #31…
-
Parent Flagged if Children Flagged
Hi all. I have a task list that consist of multiple parent rows with Children I have modifided so that if a task is delayed or dates are not added in the task will get a flag. What i would like is to have if one or more of the Cildren Rows are Flagged the parent row will be flagged. but cant figure it out. Ivé tried with…