If Formula Help

Options

I need a formula to fill in a checkbox if the first name matches the first name of another sheet, last name matches, and it contains the position name Logistics. Thoughts?


=IF([First Name]@row = {First Name}, IF([Last Name]@row = {Last Name}, IF(CONTAINS("Logistics", {Position}), "true", "false")))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!