I'm developing list for managing a project with 11 columns each representing a project milestone.
We'll call them A,B,C...K.
"A" representing a status of "Project Started" and K representing "Project Complete" with various statuses in between.
When a milestone has been reached, the date is input into the appropriate column. So when the project is complete, there will be dates in all columns A-K
I wish to incorporate a new column that indicates the current status depending on if columns A-K have been filled in.
So if all columns are blank, a status of "Awaiting start" is indicated.
If column A is filled in with a date, a status of "A" is indicated.
If columns A and column B are filled in then a status of "B" is indicated.
If columns A, B and C are filled in then a status of "C" is indicated. * * If all the columns are filled in with dates, a status of "K" is indicated.
Any ideas? Some form of If statement in a calculated Status column?