Hey guys.

I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status.

Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per


Here is the formula I'm using...

=IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete")))

The formula works to identify Future and Late


I have been attempting set up a relational database for multiple client use.  This database should track records (rows including child rows) as it progresses through different phases.  Projects may stop periodically and should be searchable and may be re-started later.  I have tried using 3 column