How to add Checkboxes into IF(AND formulas.

I'd like to be able to pull in when a checkbox is marked off in another sheet.

Sheet 1 has multiple Project IDs. Associated with each project is a checkbox to indicated whether the scope of the project will be impacted.

Whenever a checkbox is marked off for a project in Sheet 1, I want to capture that in a separate sheet.

So far, I have the following, where {CA - PPM Project ID} and {CA - PPM Scope Impacted} are columns from Sheet 1.

=IF(AND(({CA - PPM Project ID} = [Project ID]@row), {CA - PPM Scope Impacted} = "1"), "Yes", "No")

I've tried a couple of variations on this, but nothing seems to be working.

Thanks for your help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!