IF(NOT(ISBLANK & IF(ISBLANK - Getting #INCORRECT for one part of the formula


I am only getting the correct answer for the first part of this formula. The second part IF(NOT(ISBLANK...is giving me an #INCORRECT ARGUMENT SET.

I would like to populate the "PROJECTED FEE" column with the number in "PROJECTED FEE - NO REFERRAL" if "Firm Fee" cell is blank, and if "Firm Fee" is not blank then the "PROJECTED FEE" cell should be blank

=IF([Firm Fee]@row = "", [PROJECTED FEE - NO REFERRAL]@row - [Referral Fee Amount]@row, IF(NOT(ISBLANK([Firm Fee]@row = ""))))

Hope that makes sense. Thanks



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!