Looking for Nested IF formula support, unless that's the wrong formula set...

Jen Lawson

Looking to get specific terms to auto-populate the "Production Status" column, based on where the current Actual production line up is done to.

For example, if a date is entered (manually) for Capping Actual, then Production Status would say "Capped". If IVT/ Uncapped Actual had the last date it would say "IVT" for Production Status, etc. I can get the formula to work for ONE date, but not all strung together. I am working the formula from right to left, so I catch the most recent completion step (LNP is the next step AFTER Capping)... So I want LNP Actual, Capping Actual, IVT/ Uncapped Actual, LP Actual, Construct Actual then "Pending".

Above is what is in there, right now... I was thinking maybe it was failing because it needs an- if nothing do this...hence "Pending".

HELP!

Paul Newcome

You need to get rid of the OR statements.

=IF([LNP Actual]@row <> "", "LNP", IF([Capping Actual]@row <> "", "Capped", "Pending"))

Paul Newcome

You need to get rid of the OR statements.

=IF([LNP Actual]@row <> "", "LNP", IF([Capping Actual]@row <> "", "Capped", "Pending"))

Jen Lawson

OMG, this is so perfect. I am so excited! Perfect!!!!!

Thank you very much!

Jen

Paul Newcome

Happy to help. 👍️