Formula Question: IF Not Blank, Do "This"

Options

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", "")

Best Answer

  • Summer
    Summer ✭✭✭
    Answer ✓
    Options

    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.

Answers

  • Summer
    Summer ✭✭✭
    Answer ✓
    Options

    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.
    Options

    Thanks Summer - This works!

    Have a nice weekend!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!