Checkbox & Pulling back values in a cell



I've done my research and it looks like people have had to use Zapier for this specific use, but want to throw it out there again before i go that route!

I am looking to pull back a value from a row where a box was checked. So i am thinking that in my formula sheet i can create a formula that basically says 'if the box was checked in @row, pull back the value from Column A @row'. I've used If statements before + nested formulas, but not sure how to finnagle this one!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!