Look up 2 columns conditions and return 3rd column value

Hello Experts,

I want to look at values from Creation Week and CR_Current Week columns and return values from CR_Start Date. I have given the lookup criteria in Column G2 and G3 and want to return the value in G4.





Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!