COUNTIF and IF statements nested together - INCORRECT ARGUMENT SET

Options
vivekr
vivekr
edited 12/09/19 in Smartsheet Basics

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

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • vivekr
    vivekr
    edited 07/24/19
    Options

    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å
    Andrée Starå ✭✭✭✭✭✭
    Options

    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.