Text/String Version of Max formula

I have a sheet where I am writing rows and not all entries will update each column. I want to reference that column on another sheet and only return the value that is not blank. I can't quite get the ISBLANK formula to work for this.

I've done this with dates using =MAX(range). Not sure how to accomplish with text.

Thanks for the help in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!