-
Formula issue with #NO MATCH (Using IF and IFERROR)
Hi I have the following formula: =IF(AND([Attended over 6 months]@row = "Green", Interview@row = "Green", [Referee Check]@row = "Green", [Blue Card Linked]@row = "Yes"), "Yes", IF(OR([Attended over 6 months]@row = "Yellow", Interview@row = "Yellow", [Referee Check]@row = "Yellow", [Blue Card Linked]@row = "Hold"), "Hold",…
-
Help with formula that has negative numbers
Hi, I am trying to work out a formula that would return the below # value so I can then change status in a different column 0% to 25% = "1" 26% to 100% = "2" -1% to -25% = "3" -26% to -50% = "4" -51% to -100% = 5 this is the formula that I am trying to get to work, it only gets so far and then stops. '=IF([% Completed Vs…
-
formula to exclude items
I need to make a Sum of a column "Estimated Annual Revenue" but filtering by different options that I have in a column "Provide Client Sector", for example Commercial items and excluding from other column called "Status" items with "Cancelled", "Declined" and "Implementation complete" I have this formula now working but…
-
Averaging RGB balls
I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue balls on the Children rows...make sense? Help would be much appreciated, screen shot…
-
3+ Levels of Filter Groups
I know I've seen this filter setup before but I cannot seem to recreate. I am trying to layer 3 or more filter groups to attain the desired logic. Is this feasible?
-
Unwanted Default gray background of the dropdown selections
Hello, I am trying to change the backgound color of the Dropdown selections that appear in the cells to white. Is this possible? is there any CSS formatting i can give to the background of the dropdown selections? I would like that gray background gone please
-
Sheet to Sheet with Parent Rows
I have created a sheet that when a check box is marked it moves the entire row to another sheet. I was wondering if there is a way that when the row moves to another sheet if I can have it populate the information under a parent row? Example my Scheduling sheet moves the row to my Machine sheet. My scheduling sheet I make…
-
Formula to update status on a parent row based on child row with OR statement
Hi - I need a formula to update the status on the parent row based on status values in the child rows below. I am wresting with this formula and hoping someone on here can point me in the right direction. I found this post which is exactly what I'm looking for but there was never an answer to her last comment about needing…
-
formula handbook for EU region
could you give access to the formula handbook to all regions? Thanks
-
Need help with a VLOOKUP formula
Hi all, Just to be upfront, formulas are my Achilles heel, so I'm not sure if I'm doing this right. My company has a Lucidchart training coming up, and we've created a sheet/form that will list out everybody who has filled out the form and has expressed interest in the training. I've also imported another sheet that lists…