Results 1 to 3 of 3

Automatic Task Display

Threaded View

jcornish Automatic Task Display 02-19-2007, 06:42 PM
rylo Hi Here's one way. on... 02-19-2007, 09:12 PM
jcornish Thanks heaps champ - works... 02-20-2007, 10:34 PM
  1. #1
    Registered User
    Join Date
    02-19-2007
    Posts
    14

    Automatic Task Display

    Hi Guys n Girls,

    Wonderful site - hopefully someone will be able to solve my little dilemma.

    I am creating a new sheet for my processing team, and want to have a the next task for each client apprear automatically. This occurs when a new date is entered along the row. I created a IF statement that works quite well (while being ugly), but i will need more than 7 nested formulas to cover all of the tasks they do.

    =IF(E2="","Follow up Relevant Pages",IF(F2="","Follow up Submission",IF(G2="","Chase AIP",IF(I2="","Chase O/S & Follow up Vals",IF(K2="","Follow Up FA",IF(L2="","Follow Up LDS",IF(M2="","Has Client Signed Docs","Follow up Settlement Date"))))))) etc etc

    Is there any way for me to have tasks displayed to cover the entire process?

    I have attached the sheet.

    Thanks for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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