COUNTIF/AND/THEN CHECK A BOX OR SYMBOL
FORMULA 1I need a formula that will "count 5" check boxes and a "contain" to either "check a box or a symbol."
Answers

Hi @Bobby1 !
If I'm understanding the scenario correctly, this should work:
=IF(AND(COUNTIF([data entry]@row:pca@row, true) = 4, review@row = "1Complete"), true, false)
It will check on (true) your Complete column if there 4 checks AND Review = 1Complete.

thank you.. it returbed invalid or incorrect
=IF(AND(COUNTIF([Data Entry]@row:[PCA STAMP]@row, true) = 4, [Fiscal Review]@row = "1Complete"), true, false)

Hi @Bobby1
What type of column are you putting the formula into?
This is built to be written into a checkbox type of column:
=IF(AND(COUNTIF([Data Entry]@row:[PCA STAMP]@row, true) = 4, [Fiscal Review]@row = "1Complete"), true, false)
However if you're using Symbols, you'll want to change the input at the end:
=IF(AND(COUNTIF([Data Entry]@row:[PCA STAMP]@row, true) = 4, [Fiscal Review]@row = "1Complete"), "Yes", "No")
Cheers,
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!