I need to quickly fix and update some sheets my team has created. Id like to return a result to cells on a new sheet based upon input on a first sheet. The example I pose goes like this:
when my production team member completes a product fabrication, it is logged on a sheet with date of completion (or could be a simple checkbox).........id like this data to be auto-populated into another sheet kept by my financial and administrative team to prompt action by them. Im pretty sure based on my novice level understanding that an "IF" logical argument function is where to start.............
Can one of you experienced folks help? thanks so much in advance
