How to look at multiple columns in a row and return the last "Not Blank" cells in the current cell


I am wanting to populate the last date that a quote was done (Quoted Price Option date) into the "Date Last Quoted Price" column. Is there a formula that will do this? Every row will have the last date a quote was done in a different column.

Thanks for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!