I want to write a formula to return one of 2 cell values


I have 3 cells in play here. Cell 1 is a formula pulling a value from "Grid A". Cell 2 is pulling a value from "Grid B". There is typically either going to be a value in cell 1 OR a value in cell 2, which means one of those 2 cells likely says "NO MATCH". How can I teach column 3 to pull in the value for the cell that does not say "NO MATCH". I've tried this with no luck (simplified the cell names for this post):

=IF([Cell1]@row CONTAINS("MATCH",[Cell1]@row),[Cell2]@row,[Cell1@row


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!