Inspect Cells Until Contents Found, Then Copy to Another Cell
I'm trying to create a column ("Latest Site Visit Notes") on my sheet that fills in with the latest site visit notes. We have existing columns for "Construction Supervisor Visit 1 Notes" thru "Construction Supervisor Visit 20 Notes". Our hundreds of projects all have various quantities of site visits performed so far.
I'd like the "Latest Site Visit Notes" column to inspect column 20 for contents, if blank then it'll inspect 19, if blank then inspect 18, if not blank then display that column data in "Latest Site Visit Notes"
Can this be accomplished with a Workflow or just with some cell code? I think I can figure out how to do it with a Workflow but it looks like it'll be huge and possibly resource intensive.
Thanks for the help.
Help Article Resources
Check out the Formula Handbook template!