COUNTIF and IF statements nested together - INCORRECT ARGUMENT SET

I'm trying to select a range for the completion status and also trying to refer to a different column and get the data updated in a different column. I'm sure I'm doing something wrong here. Please help me!

=IF(COUNTIF([Completion Status]3:[Completion Status]38, 0) > 0.5, "Not Completed", "Pending Mgmt Approval", IF([CEO Approval]3 = "Approved", "Completed", "In Progress"))

Screen Shot 2019-07-24 at 4.02.38 AM.png

Find more posts tagged with

Conditional Formatting

Comments

Andrée Starå

Hi,

Yes, that formula won't work, and I'm not sure how you want to use it.

Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

vivekr

https://www.loom.com/share/97f0ac40869e4f73992cc4f77ca2ac1a

I shot a screen video of it and explained the problem also.

Thank you for your help.

Andrée Starå

Hi Vivek,

I answered in your other post but here it is as well.

Try something like this.

Change the row numbers to match your sheet. I haven't included the In Progress status because I wasn't sure what criteria would decide if it's in progress. What would you lie to use for In progress? When over one checkbox is checked?

=IF([CEO Approval]@row = "Approved"; "Completed"; IF(COUNTIF([Completion Status]4:[Completion Status]8; 0) > 0,5; "Not Completed"; "Pending Mgmt Approval"))

The same version but with the below changes for your and others convenience.

=IF([CEO Approval]@row = "Approved", "Completed", IF(COUNTIF([Completion Status]4:[Completion Status]8, 0) > 0.5, "Not Completed", "Pending Mgmt Approval"))

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 day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Unable to find team members in search function to share a sheet with
I am trying to share a Sheet, can't find some people in the search function. Why not?
Permissions not updating
I was given editing permissions this morning but when I open the sheet it still says I am View Only.
indent for entire cell
Hi I'm trying to make indent for 78 groups, is there a way to make it in one click or I need to do it one by one. see image below, e.g., I want contioue up to B-78, and that takes a lot f time. Any suggestion?