Change Status Depending on Populated Cells

[Razaster]

Hi,

I'm trying to change the status in Cell F4, 5, 6 etc. based on whether cells I, J, K, L, M or N are populated (i.e. a date is in cell I4 then in cell F4 the status would be "Programmed", then if Cell J4 has a date the status will change to "Letter Sent")

Anyone had a similar requirement?Capture.PNG

[Special-K]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.

Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

[Razaster]

Hi,

Thanks for the reply - I've attached as described

[Special-K]

That's an image, see where it says "Attached image"

I asked for a spreadsheet.

[Razaster]

Apologies!,

Spreadsheet attached - I've put under the table what i'm trying to achieve, thanks for your help

[JeteMc]

This proposed solution employs helpers, which have been placed in row 1048576 for demonstration purposes.
The helpers state the names of the statuses, aside from completed, in the columns corresponding to the column header in row 3.
The array entered formula* that populates the 'Current Status' cell is:

Please Login or Register  to view this content.

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.

[Razaster]

Thanks guys, works fantastic!

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

[Razaster]

Hi Everyone,

I've added some additional columns which has rendered this formula void - can anyone rejig the attached to get it working again?

[JeteMc]

Try the following:

Please Login or Register  to view this content.

Select cell K2
Paste the formula into the formula bar
Drag the fill handle down to cell K13
Let us know if you have any questions.