Results 1 to 4 of 4

Location Status Formula Only Working for First Row

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2019
    Location
    Gardner, MA
    MS-Off Ver
    365
    Posts
    10

    Location Status Formula Only Working for First Row

    I made a spreadsheet to update a location/site status when data is entered into specific cells. Column A is the location by Site ID, column H is the Assigned Tech, and Column I will be a yes or no entry once the work has been completed. I want the site status in L2 to update from "Not Started" to "In Progress" once a tech has been assigned and then "Done" once the done column has been marked. The formula I have seems to be working, but only for the first row. If I enter a Site ID into K2 that is any other row other than row 1, the status is "Not Started" even with data in the Assigned Tech and Done columns. Help please!
    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. [SOLVED] Formula to determine number of units at each location and status of units
    By Klimer in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-18-2016, 10:01 AM
  2. Replies: 3
    Last Post: 09-11-2014, 04:32 PM
  3. VBA - Working with Excel 2007 and SharePoint, checking file status
    By waynegro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2014, 11:06 AM
  4. Replies: 1
    Last Post: 04-05-2014, 03:07 AM
  5. Default File Location not working
    By treymass in forum Excel General
    Replies: 3
    Last Post: 04-19-2013, 04:22 PM
  6. Replies: 4
    Last Post: 04-08-2012, 09:43 PM
  7. default file location not working
    By cs_hart@yahoo.com in forum Excel General
    Replies: 0
    Last Post: 04-26-2006, 10:30 AM

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