This project is FileMaker 11
I have a 14 day time period and we know the start date
there are 8 milestones in between start date and end date(which is calculated)
as time passes, each milestone needs to be evaluated for On schedule or behind schedule
the result of each milestone evaluation does not need to permanently captured (although this may be a feature needed at a later time so I would love some ideas on this as well)
The result of the evaluation does need to be displayed in the calculated Status field until the next milestone arrives and is evaluated for "On Schedule/Behind Schedule"
There are manually entered and calc date fields that the evaluations are test against:
Milestone 1 is On Schedule if the date of its completion is Equal or less than start_date +2, if greater than, it is Behind Schedule
Milestone 2 is On Schedule if the date of its completion is Equal or less than start_date +3, if greater than, it is Behind Schedule
and so on until the 14 days have been evaluated.
I have had no success using Nested IF statements which I thought were the only way to keep the calculation going after the first result tested true.