Formula Question: IF Not Blank, Do "This"
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
-
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
-
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.
-
Thanks Summer - This works!
Have a nice weekend!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!