IF AND COLLECT?

Options

I need help with creating a formula that will collect the value in the [Level] Column with the following criteria:

[Area Helper] =1 and [Operational Area] = "Airside"

Thank you! - Ron

Source Sheet:

Destination Sheet:


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!