COUNTIF and IF statements nested together - INCORRECT ARGUMENT SET

vivekr

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"))

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