-
IF AND OR Statements
Hello! The sheet on the back end has multiple checkmarks to select what role the event is for. I am needing to create a formula that will give a Academy name based off of which checkmarks are checked. The column for academy name is a dropdown column. i.e. If support office is checked support office academy is put in the…
-
Getting sheets to talk to one another
I have two different sheets and I need them to automatically populate cell data when data is entered. I have sheet A (my department sheet) that has many columns and rows (many of which won't apply to B) and I have sheet B (another department sheet) that has a lot less columns and rows. I have set-up a column in each sheet…
-
Return latest Update
Hi Guys I have sheet - Incident Recoded, see pic below…. I have formula - =IFERROR(INDEX(COLLECT(CHILDREN([Incident Description]@row); CHILDREN(Modified@row); MAX(CHILDREN(Modified@row))); MATCH("MTC"; CHILDREN([Primary Column]@row); 0)); "") This formula works if on row 2 in the pic the Incidents is "MTC" but if the 2nd…
-
Trying to get a list of distinct values across multiple columns based on multiple criteria
Hi, I am trying to list all the distinct values for the Year 1 through Year 4 columns but only for the rows the WBS row value is equal to WBS Target value and skip any blank cells. I have a helper column to index up to 10 distinct values (Screen shot below) Any help is greatly appreciated!
-
Lastest Update
Hi I have sheet - Incidents Recorded for the Month, which record the incidents that occuring within a month. see the pic below…. I want a formula that can return the latest Incident Description when a new incident is added. I have used the following formula - =IFERROR(INDEX(COLLECT(CHILDREN([Incident Description]@row);…
-
My risk formula for program row with child Projects progression is not working.
I am tryings to create a risk formula for Program that has list of projects as a child. Following are conditions to mark the project as either Green, Yellow, Red or Blue: Blue: - Project has progress (% Complete > 0) but hasn't officially started yet (Start Date is in the future) - Indicates early progress or a potential…
-
Check box if date is equal to or between dates
I want to create a formula to do the following: If the "Created Date" is equal to OR between the "Week Start" and "Week End" dates, I want to check the "Submitted on Time" box. I tried =IF([Created Date]@row, >=[Week Start]@row, <=[Week End]@row, 1, 0) and am getting an INCORRECTARGUMENT error. I'm sure I'm missing…
-
Balls Changing Colors
Hello, Why is the signal status color column populating a color when I have nothing in the value column? How do I stop this? My current formula is =IF(Value@row >= 90, "Green", IF(Value@row <= 84, "Red", IF(Value@row < 90, "Yellow"))) Thanks!!
-
Problem with nested IF statements
I was successfully able to write a formula to fill in the value of the User 2 Action column with the value of User 1 Action if Prod User 2 is not blank: =IF(AND(NOT(ISBLANK([Prod User 2]@row)), NOT(ISBLANK([User 1 Action]@row))), [User 1 Action]@row), "") I would like to add one more level to this where the above works…
-
Rolling updates - can I automate data selection for dashboard?
I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes…
