Results 1 to 4 of 4

Logical Formulas for Schedule Creation

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2013
    Posts
    4

    Logical Formulas for Schedule Creation

    I'm making a schedule for special guests who are participating in a four day multi-event festival. Each guest will be involved in a different combination of rehearsals and performances at different times and on different days. I have created a multi-page spreadsheet, where the front page is the master schedule for each person and the ensuing sheets are each individual event schedule with all its rehearsals and people.

    I have set up the front page to basically just say whether any specific person is free or not in any given time slot (here is an example formula =OR(ISTEXT('Event 1'!B3),ISTEXT('Event 2'!B3), ISTEXT('Event 3'!B3), ISTEXT('Event 4'!B3) etc.) - this leaves me with TRUE meaning they are busy and FALSE meaning they are free at that time.

    My questions are the following:
    1) Is there a way for me to instead have it generate WHICH sheet is generating the TRUE value, instead of just saying TRUE?
    2) Is there a way for it to generate an error message if I've double booked the person, i.e. if more than one of the values is true?
    3) If I can't do number 1, is there a way for me to change "True" and "False" to say "Busy" and "Free" in an OR function?

    I don't mind totally starting over with a new approach if I can end up with a formula on my master schedule that says, say, at 9am they are busy with event 3, at 10am they are busy with event 5...

    I've attached my blank template so you can see how the data WILL be organized, even though there isn't any data in there at the moment, just my example formula.

    Any insight is appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Nested Ifs Logical Help to auto populate a schedule
    By alienj19 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-18-2012, 12:28 PM
  2. Rota creation, Job Type vs. 2 shift work schedule
    By Ponderatul in forum Excel General
    Replies: 0
    Last Post: 08-20-2012, 07:02 AM
  3. Logical Formulas Help Please!
    By cambriccharles in forum Excel General
    Replies: 1
    Last Post: 10-12-2009, 11:41 AM
  4. Replies: 13
    Last Post: 01-15-2006, 01:15 PM
  5. [SOLVED] More work schedule creation trouble
    By Paul in forum Excel General
    Replies: 4
    Last Post: 12-11-2005, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1