Help w/countif for blank fields

jmo

Hi team - I'm trying to create a nested COUNTIF function that returns either Not Started or In Progress in the Update Status column if any or all of the specific column rows are blank, otherwise show Complete.

Update status column has Not Started, In Progress, Complete as drop-down menu options.

I tried the following formula but it keeps coming back, the dreaded, UNPARSABLE:

=IF(COUNTIF([1. Aware of MS vulnerability?]@row,<>"") + COUNTIF([2. Use of any affected on-prem listed MS Exc Svr?]@row,<>"") + COUNTIF([3. Which MS Exchange Server version(s)?]@row,<>"") + COUNTIF([4. Describe DHS action steps taken]@row,<>"") + COUNTIF([5. Have malicious actors accessed your network?]@row,<>"") + COUNTIF([5. Have malicious actors accessed your network?]@row,<>"") + COUNTIF([Comment/Validation/Verification]@row,<>"") = 0, "Not Started", "In Progress"))

Snippet from the actual page:

What am I missing?

Mike Wilday

Remove the extra closed parenthesis at the end and you should have it. IF that doesn't work, try testing your countifs addition without the if statement.

=IF(COUNTIF([1. Aware of MS vulnerability?]@row,<>"") + COUNTIF([2. Use of any affected on-prem listed MS Exc Svr?]@row,<>"") + COUNTIF([3. Which MS Exchange Server version(s)?]@row,<>"") + COUNTIF([4. Describe DHS action steps taken]@row,<>"") + COUNTIF([5. Have malicious actors accessed your network?]@row,<>"") + COUNTIF([5. Have malicious actors accessed your network?]@row,<>"") + COUNTIF([Comment/Validation/Verification]@row,<>"") = 0, "Not Started", "In Progress")

Mike Wilday

Remove the extra closed parenthesis at the end and you should have it. IF that doesn't work, try testing your countifs addition without the if statement.

=IF(COUNTIF([1. Aware of MS vulnerability?]@row,<>"") + COUNTIF([2. Use of any affected on-prem listed MS Exc Svr?]@row,<>"") + COUNTIF([3. Which MS Exchange Server version(s)?]@row,<>"") + COUNTIF([4. Describe DHS action steps taken]@row,<>"") + COUNTIF([5. Have malicious actors accessed your network?]@row,<>"") + COUNTIF([5. Have malicious actors accessed your network?]@row,<>"") + COUNTIF([Comment/Validation/Verification]@row,<>"") = 0, "Not Started", "In Progress")

jmo

Doh!!! It's always the littlest thing. 😋

It absolutely was the last parenthesis in the string.

Thanks for your speedy reply @Mike Wilday !!!

Mike Wilday

AWESOME. Yes...The littlest thing can create the biggest headaches! 🤣

You're welcome. Have a good week!