Help me write a conditional formula - please!
 

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!

Help me write a conditional formula - please!
 

I'm not sure what you are trying to do, but do you mean dynamic formula? If
you add new information the formula copys automatically?

"Leslie" kirjoitti:

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!

Help me write a conditional formula - please!
 

I apologize if my explanation of the problem was unclear or confusing.
Perhaps I don't know the correct terminology to use to describe the solution
I was looking for. The problem was solved using the recommendation from
another responder to place INDEX and COUNTA functions in the formula. Thank
you for taking the time to respond!

Leslie

"NeedToKnow" wrote:

I'm not sure what you are trying to do, but do you mean dynamic formula? If
you add new information the formula copys automatically?

"Leslie" kirjoitti:

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!