Sign in to join the conversation:
I need to color a ball yellow if the value in a column is between .05 and .15. If the value in the same column is greater than .15 OR a checkbox is selected, I need the ball to be red. Not sure how to accomplish this. Appreciate your help.
Try:
=IF(OR([Check Box]@row = 1, [Value Column]@row > 0.15), "Red", IF(AND([Value Column]@row >= 0.05, [Value Column]@row <= 0.15), "Yellow", "Green"))
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
I have a risk sheet with a system generated id column (ACT-0001); etc. In the risk sheet I have a helper column to identify if the risk is linked to a task in my project plan sheet. In my project plan sheet, I have a column called RiskID that contains a string of risks (ACT-001; ACT-0002; etc.) linked to a task. The risks…
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
