Index collect with checked cell

The formula works fine, but what I really want to is that the IP (in column3) would only appear when the check mark (at column2) is checked. Is there anyway of doing that?

Can anyone help?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!