Myopic Matt
New Member
- Joined
- Jul 10, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
I have a project spreadsheet wherein I am trying to perform a v look up based on what the status is for a project with the goal to spit out the "time card last submitted date" for only "in progress" projects while stating a text field for projects that are not "in progress". This is created works =IF((E2="in progress"),VLOOKUP(A2,'Projects Data'!$A$3:$AU$251,10,FALSE),"Project Not In Progress") and the formula provides either the time card submission date or "Project Not In Progress"...
MY PROBLEM is some of the projects do not have a time card last submitted date (blank field) so the formula spits out "1/01/1900" for these. I really need the formula for "in progress" projects without a time card last submitted date to be flagged with another text warning.. Any thoughts appreciated! Thank you.
I have a project spreadsheet wherein I am trying to perform a v look up based on what the status is for a project with the goal to spit out the "time card last submitted date" for only "in progress" projects while stating a text field for projects that are not "in progress". This is created works =IF((E2="in progress"),VLOOKUP(A2,'Projects Data'!$A$3:$AU$251,10,FALSE),"Project Not In Progress") and the formula provides either the time card submission date or "Project Not In Progress"...
MY PROBLEM is some of the projects do not have a time card last submitted date (blank field) so the formula spits out "1/01/1900" for these. I really need the formula for "in progress" projects without a time card last submitted date to be flagged with another text warning.. Any thoughts appreciated! Thank you.