-
How can I label rows based on their level 0 text?
I'm looking for a column formula that will apply the text from level 0 to all of its children, grandchildren, etc. My sheet has multiple level 0 rows.
-
Service log / mileage tracker
I am using a form which has an individual input the current mileage of a vehicle every time they use it. This would need serviced every x amount of miles. I am wanting to set up an automation that will email a specific person whenever it's time to service the vehicle. I guess right now I am trying to find a way to do this…
-
How to make tasks health status column more accessible by include color words
Hello, I am trying to make the health status column more accessible by including words to match the colors (e.g. 🟢 green, 🟡 yellow, 🔴 red). Does anyone know how to do this?
-
Revise Formula to include a but
My current formula in one column that is working out is the below: =IF(OR(CONTAINS("Term", [Column1]@row), [Column2]@row = 1), "Green", "Yellow") For the next column I need a revised formula to say "if the term is in column 1 and column 2 is check BUT Column 3 is checked then it will give me a red ball" What do I need to…
-
Auto populate formula column not showing up on report
Hello! I have a sheet with a formula to auto populate a checkbox is a status is entered. The checkbox formula works on the sheet, but when I created a report to pull the checkbox column, the column is empty and will not show the checkbox. Did I do something wrong? Is there a way to populate the column in the report and…
-
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!
