Sign in to join the conversation:
Per the attached screen shot. How would the formula be written so that the row2 flag turns red IF any of the flags(row3-row11) are toggled to red?
Thanks
Hi Daniel,
Try this.
=IF(COUNTIF(CHILDREN(); =1) > 0; 1; 0)
The same version but with the below changes for your and others convenience.
=IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Works! Thank you!
Excellent!
Happy to help!
Andrée
This discussion was created from comments split from: Multiple IF/AND Formulas - Need Nesting Help.
I am trying to write a cross sheet countifs formula. (COUNTIFS({Ref. Sheet Column}, [Requirement Name]@row , {Ref Sheet Checkbox Column}, 1 > 0) Something isn't right as I am expecting to return a checkbox on the target sheet where the formula is being written based on the conditions of the source sheet. Thank you
I need help counting the data in a column if a cell on that row is not blank. I want the count of Serial numbers from the "Serial" column if the actual completion date field is blank. This is the current formula I am trying to use that is not working: =COUNTIFS([Actual Completion Date]:[Actual Completion Date], "",…
