Formula for If Then statement Error Incorrect Argument Set

Rebecca Menning

Desired Objective:

Working on a column formula for Baseline Pass/Fail # Records with Errors

If Baseline # of records audited = blank then blank

If Baseline Audit Fail Rate Formula is greater then 20 then "Fail"

Else "Pass"

Paul Newcome

Your parenthesis are off. Your original formula should work as long as you remove the error from the [Baseline Audit Fail Rate Formula] column.

=IFERROR(original_formula, "")

Matt Lynn-PCG

@Rebecca Menning Try:

=iferror(if(isblank([Baseline # of records audited]@row)),"",if([Baseline Audit Fail Rate Formula]@row>.2,"Fail"),"")

Rebecca Menning

Still getting an incorrect argument set error

Paul Newcome

Your parenthesis are off. Your original formula should work as long as you remove the error from the [Baseline Audit Fail Rate Formula] column.

=IFERROR(original_formula, "")

Rebecca Menning

As always, your quick response saved me hours of frustration. The Smartsheet Community is appreciated by BJCMG