-
Nested Index/Match works but getting #No Match would like to return blank but can't get formula
=IFERROR(INDEX({Braden's Project List Range 4}, MATCH(Project@row, {Braden's Project List Range 3}, 0)), INDEX({Braden's Project List Range 2}, MATCH(Project@row, {Cody's Residential Project List}, 0)), "")
-
STATUS FORMULA
Hi Community, I always struggle with the status formulas. There are 5 status points: Not started - identified by the [DATE HA WAS ASSIGNED] (I want it so if the cell is blank it results as Not Started). In Progress - HA - identified by the [DATE HA WAS ASSIGNED] (I want it so if there is a date entered the status changes…
-
What is wrong with my formula??
The first part of the formula works because I made changes (putting in one date in [Panel Date]2) to the sheet to get one of the true_values in the IF function and it came back correct, but when I try to make the same changes farther down my sheet (adding a date to [Panel Date]6) that matches the rest of the formula, this…
-
When copying rows from Sheet1 to Sheet2 the Unique ID overlaps the value in the destination
I have a master sheet that holds contracts and a secondary sheet that manages Invoice orders. When a contract is approved a workflow then copies the contract row to the invoice orders as many times as invoice should be produces in the particular contract. I originally thought of using the auto number column to…
-
2 counting dates in a column formulas
I have two simple counting formulas that aren't working for me. I have searched other questions/answers and tried their solutions, but it still doesn't work for me and I don't understand why. Here's a snippet of my data: The first thing I'm trying to do is count how many dates (not counting days) are listed in "Year…
-
Symbol Function
IF([CEO Approval to Close]@row = "Approved", "Red"), =IF([CEO Approval to Close]@row = "Declined", "Yellow") I am trying to get it so that if approved the symbol is the red circle, declined as yellow. If I only have the first part in the line it works, but when I try to add in the declined piece I get error messages. What…
-
Formula
Hello again, I need help with how to set up a formula for my dashboard. How do I create a formula that tells me how many Task and CAR's were issued per month? Please advise, thanks!
-
How do I show parents when filtering on tasks
I am filtering specific tasks based on resource, sub-system, Function etc. The filters are working fine, however I would like to see the associated parent tasks. So if tasks from level 2, 3, 4, ... are shown, I want to see their parent tasks shown up to level 1 or 0. Similar to how MS Project does.
-
how to set the timestamp in a cell if another cell (status) has changed
Hi all, cell "status" is set to "open", "work" and than "finished". I would like to set cells "open status date", "work status date", "finished status date" with the timestamp of the change of "status". How could this be done? Workflow is not able to set the value of a cell :-(. Thank you
-
Average Formula not Ignoring Blanks
Hello! I am having problems with the below formula (its a big one). I am trying to avoid creating 9 helper columns if possible. The below formula is including blank cells as 0s when averaging. I have tried a variety of combinations of OR, <>0, etc and cannot find a way to skip the blanks. Some of what I have tried will…