Combining Two If statements


I am trying to combine the following two if statements and every time I try, it gives me an error.

=IF(NOT(ISBLANK([Date Submitted to AP]2)), "Yellow")

=IF(NOT(ISBLANK([Fulfillment Receipt Received]3)), "Green")

Any help would be greatly appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!