-
Sum Cells Based on Data in Two Columns
I need to sum the Cost Per SKU for Transfer ID based on the Uniqueness of the Transfer ID. My brain cannot come up with a way to do this even though I know it is probably possible. What formula do you recommend? Here is a snapshot of the helper columns I already have and the two columns with data.
-
I need to change a column named Event Type to a "V" or "I" based on the value of another column.
I need to change the Event Type column to a "V" or "I" if a column named Event location contain the word "Virtual" or "virtual". I have tried several versions of IF statements but they all give errors. Below is the last version I tried. =IF([Event Location]@row, "Virtual", "V", IF([Event Location]@row, "virtual"), "V",…
-
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…
