Formula Question: IF Not Blank, Do "This"

Corey D.

Hi,

I'm looking to create a formula within our 'Status' column that auto populates a particular status based on what three columns inputs are (see below snip).

What I would like is if 'PO Number' & 'Received' are blank, then "REQ Submitted" populates.

If 'PO Number' is not blank, but 'Received' still is then I would like it to show "PO Received/Pend Item Receipt"

Finally, if 'Received' is green, I'd like 'Status' to show 'Ready for Install'.

I thought to build off the formula below, but I'm having trouble getting this to work out. Any suggestions are greatly appreciated!

=IF(NOT(ISBLANK([REQ Number]@row)), "REQ Submitted", "")

Summer

Hi @Corey D.

This is a little messy and will need to be refined, but I thought it would be better than nothing.

=IF(AND(ISBLANK([REQ Number]@row), ISBLANK([PO Number]@row)), "REQ SUBMITTED", IF(AND(NOT(ISBLANK([PO Number]@row)), ISBLANK(Received@row)), "PO Received/PEND Item Receipt", IF(Received@row = "Green", "Ready for Install", "PO Received/Pend Item Receipt")))

I hope this helps. Have a lovely weekend.

Summer

Hi @Corey D.

This is a little messy and will need to be refined, but I thought it would be better than nothing.

=IF(AND(ISBLANK([REQ Number]@row), ISBLANK([PO Number]@row)), "REQ SUBMITTED", IF(AND(NOT(ISBLANK([PO Number]@row)), ISBLANK(Received@row)), "PO Received/PEND Item Receipt", IF(Received@row = "Green", "Ready for Install", "PO Received/Pend Item Receipt")))

I hope this helps. Have a lovely weekend.

Corey D.

Thanks Summer - This works!

Have a nice weekend!