-
Formula to filter for active rows
I am using a sheet to track many different projects, some of which have milestone subrows, some which do not. I want to be able to filter out projects that have been fully completed (either no child rows and status = completed OR all child rows = completed and parent status = completed) but show the milestone subrows for…
-
Looking for Help / Guidance
Greetings, Looking to do something extremely simple but just cannot get it done. Hoping that the folks in this community can assist. I have 2 sheets. See below. Sheet A: Sheet B: All I am trying to do is .. in Sheet A ... Value of License Used for Customer Number (1234) be the Sum of all the same Customer Number ("1234")…
-
Ignore duplicate rows in a report
Hello, We record certain metrics about our clients anytime they visit our physical location. This usually isn't a problem because they don't come in too often; however, there are a few times a year when they are scheduled to be onsite multiple times a day. This leads to their name showing up repeatedly on the report we use…
-
Need Formula help!
I need a formula that will do the following: When the Date in WKU column has past place the latest NewPromiseDate from the AllPromiseDates column in the cell.
-
Checking for Duplicates and then Checking for the highest ID Code.
Hi there! We use Smart Sheet for tracking multiple components of our department. On one sheet, I want a formula to check for duplicate names and then look at the ID Code Column and I want a box to be checked for any ID Code that isn't the highest of the duplicates. I have gotten the first part of the formula to work. I…
-
Formula returning random data
I have a list of 7 courses and with each course comes specific data.The Tuition Type and SHP Item Type numbers are specific to each course. In this screenshot below, I have the courses in a dropdown list and hoping to populate the SHP Items Type and the Tuition Type columns with their corresponding data. It works for many…
-
Formula to count items in a cell separated by a semicolon
Good afternoon, could someone help me with a formula to count items in a cell separated by a semicolon and put the total in another? I have a column called: "MRA Actives codes", in which there are different medical codes separated by a semicolon, for example: I70.0: Atherosclerosis of aorta; I50.9: Heart failure…
-
Row Status Indicator in Schedule
Wrote a formula to check two items and change and indicator light. Here is the code but it is saying incorrect argument set? =IF(Status@row <> "Complete", [Due Date]@row < TODAY(), "Red", IF(Status@row <> "Complete", [Due Date]@row >= TODAY(2), "Yellow", "Green")) I have reviewed everything multiple times and cannot figure…
-
What formula could I use to nest automatically based on primary column?
Hello, Trying to make it so that information in columns b-f automatically nest under the names in column a instead of doing it manually as I have a large amount of data. For example, John Doe has a badge with two different types of access. I need those to nest under them while John Smith's access information nests under…
-
Child Parent code for schedule not working
I have reviewed the formula helper and used their code and change it up a bit but not working as it should, when I change to blocked or on Hold the Parent is not changing, here is the code =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress",…