INDEX formula that ignores specific values


I want to index a column in my sheet to bring in values from another sheet. In that formula I would like it to ignore specific values (??, NA). Is there a way to incorporate that into my formula so that I only bring in the date values and nothing else?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!