Return Non-Blank Value

Good morning, Community!

As IA Compliance20-24 will only have one value, I'm trying to grab that value into the green cell which is the summary of that section. Any thoughts? Thanks!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!