Best Formula to Use


Any recommendations on the best formula to use to bring back a value from another sheet based on 2 criteria? IF/AND , VLOOKUP?? My example is I want 72.1 value from percentage column based on cell name being CNC and Week being 4 from sheet "Week4input" into the week 4 "unparsable" field in the Week 4 sheet?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!