RobotsAteMyArms
New Member
- Joined
- Apr 24, 2015
- Messages
- 2
The title of this post is confusing as heck, so I apologize for that in advance! I know there's a way to do what I'm looking for (there's always a way), but I'm having a hard time with it this morning. I'm hoping you guys can help!
I'm looking to create a formula that will show, in the cell I enter the formula, the name of the deliverable(s) pending if the deliverable(s) do not have a received date. I can set it up to show me one at a time, but I want A2 to show me all four.
Here's what I mean: In the example below, I would want it to show "Deliverable 3" in A2, because that location is missing that deliverable. In A3, I want it to show "Deliverable 2; Deliverable 4", etc. I need it to skip over blanks and add ";"," " between text.
Where I'm getting hung up is having it check and return text, or nothing (for dated cells), on multiple. Doing them one at a time and then adding a =concatenate formula is a pain...
Right now I'm using, =IF(ISBLANK(C2),"Deliverable 1"," ") which doesn't work because I have to do it for each deliverable column separately and then because it's showing a space, instead of no value.
I have multiple deliverables that I want to report on for 700+ projects/locations, so to manually be sorting through and reading dates is just not an option.
What do you think? Is there a way to make it all one string?
I'm looking to create a formula that will show, in the cell I enter the formula, the name of the deliverable(s) pending if the deliverable(s) do not have a received date. I can set it up to show me one at a time, but I want A2 to show me all four.
Here's what I mean: In the example below, I would want it to show "Deliverable 3" in A2, because that location is missing that deliverable. In A3, I want it to show "Deliverable 2; Deliverable 4", etc. I need it to skip over blanks and add ";"," " between text.
![Q3Zhpu.jpg](/board/proxy.php?image=http%3A%2F%2Fimageshack.com%2Fa%2Fimg540%2F9329%2FQ3Zhpu.jpg&hash=52ecc0aa6f05922ac92dc33ca6263d62)
Where I'm getting hung up is having it check and return text, or nothing (for dated cells), on multiple. Doing them one at a time and then adding a =concatenate formula is a pain...
Right now I'm using, =IF(ISBLANK(C2),"Deliverable 1"," ") which doesn't work because I have to do it for each deliverable column separately and then because it's showing a space, instead of no value.
I have multiple deliverables that I want to report on for 700+ projects/locations, so to manually be sorting through and reading dates is just not an option.
What do you think? Is there a way to make it all one string?
Last edited: