Using IF/AND and blank


I'm trying to populate a cell with "Verified Lead" (from a drop-down) if Sales & Leads box is checked and Blue Button Request # is not blank.

This is what I have but it's not working:

=IF(AND(NOT(ISBLANK([Blue Button Request #]@row)), [Sales & Leads]@row, 1), "Verified Lead"))

Thanks for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!