IF formula giving me #INCORRECT ARGUMENT


I am using this formula to set status' in my sheet.

=IF(ISBLANK(Cost4), "Request Submitted", "Request Reviewed/Priced", IF(CONTAINS("Approve", [CEO Approval]4), "CEO Approved"))

I am getting an #INCORRECT ARGUMENT error. What am I doing wrong?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!