Hello. I'm looking for some help with a situation I'm having in an Excel spreadsheet. I've used Data Validation before with success, but I can't seem to nail down the required formula for what I want.
Here's what I'm trying to do:
We have an Excel file that serves as a work log. Somebody does a certain task, they log it there in a 3 column system (A, B and C).
Column A describes the type of task and it is data validated against a List. You can only choose from 3 types of task: Documents, Faxes, and Phones.
The B column contains a small summary of the work done, no need for validation there.
The C column is where things get tricky. One of the mentioned tasks, Documents, requires that you also log the number of documents processed. I want to make it so that column can only be filled if the column A value corresponds to the correct task type and only a numerical value can be input (no text). Anything else, it should show an error.
I've tried using Data Validation with both AND and IF clauses but I just can't get it to work. Is what I'm asking doable?