I have a Project Summary form that contains a "Dashboard" tab and 4 other
tabs (Project Scope, Project Status, Project Change, and Project Closure). I
want the dashboard to give viewers a quick snapshot of the project status. I
want the dashboard to reference the Project Status tab and pull the most
recent status update entry into a cell on the dashboard from a series of
individual cells on the Project Status tab. I need help writing the formula
that tells Dashboard cell "X" to go to Project Status cell "B", and if "B" is
empty, pull in the contents of Project Status cell "A", otherwise pull in the
contents of Project Status cell "B", then go to Project Status cell "C", and
if "C" is empty, pull in the contents of Project Status cell "B", otherwise
pull in the contents of Project Status cell "C", then go to Project Status
cell "D", and if "D" is empty, pull in the contents of Project Status cell
"C", otherwise pull in the contents of Project Status cell "D", etc. I
wrote the following formula ( =(IF('3-Project Status'!A36="",('3-Project
Status'!A35),('3-Project Status'!A36))) and this returns the desired result,
but I don't know how to get the formula to keep going down through series of
cells for the last status update entry. Please help me!